Macro to insert "Space" in blank cells

[ronanmg]

Hi all,

I have a problem in that I have a range of cells which are blank and are causing problems when linking with another program. I found it works when I place a space in a blank cell.

Does anyone know some macro code which will look at a range of cells A1:M5000, see if there is no entry in the cell, and if not place a space in the cell?

Any help welcome!
Cheers

 

[Jim North]

This will do it after you select the range:<pre>

Sub InsertBlanks()

Selection.Value = " "

End Sub</pre>

However, it would be better if we could fix the command you are having trouble with...
would you be willing to post it?


_________________
JRN

Excel 2000; Windows 2000
This message was edited by Jim North on 2002-08-22 09:50

 

[klb]

Select your range,
Menu, Edit, Replace
Type a space in the Replace box
Click on Replace All button

_________________
Curiosity may have killed the cat but...
satisfaction brought it back. >^;^<
This message was edited by klb on 2002-08-22 10:07