Default value in cell

[Bill Morris]

Hi

I have a spreadsheet whereby I want a formula ir VBA code to apply depending upon if another cell contains anything.

For example

A1 contain text. In B1 the user can add text, but if it is left blank then I want a dash ("-") as the default value.

If A2 doesn't contain anything then I want B2 to be left blank.

Thanks

 

[Bill Morris]

Thanks again. It's better than any way I could come up with!

 

[Bill Morris]

could be as simple as

Set myRange = sheets("Data").Range("A1:" & Cells(Rows.Count, "A").End(xlUp).Address)

Me again.

If I want this range to start from cell C38 rather than A1 and for the default "-" to appear in N38 onwards....what changes do I need to make?