I've got two coding problems:
Firstly, I am trying to replace a range of empty cells with text. This works (Sub ta2()), but not if I do this on line 4:
Does anyone know why? I don't see why I have to reenter the range when the variable has been initialised.
Additionally, I have a range of cells, some are marked as 'X' and I would like these replaced by a string 'Replace1'. Those which are null/empty, I would like to replace with 'Replace2'. I have tried the code below but it isn't working (i.e. just replaces everything with 'Replace2'). Any suggestions?
Thanks, Tim
Bookmarks