On 10 Dez., 16:37, Dave Peterson wrote:
First, this is usually a mistake to do.

It'll mess up formulas like:
=if(a1="","it looks empty","it doesn't look empty")

If you have other formulas that use these empty cells--like:
='sheet 99'!a1
and you're seeing 0's where you don't want them, try modifying your formula:
=if('sheet 99'!a1="","",'sheet 99'!a1)
The receiving cell will look empty.

But if you want...
Record a macro when you
Select column A (or the range you want)
Edit|replace
what: (leave blank)
with: (spacebar character)
replace all.

ps. *Edit|replace only works on the used range. *So if you want those space
character cells past the last used row, put something column B of the last row
you want. *Do the edit|replace and clear that cell in column B.

andreashermle wrote:

Dear Experts:

For some specific reasons I would like to enter a space in all blank
cells of the first column of my spreadsheet called sheet 1.

How is this done by using VBA?

Help is much appreciated. Thank you very much in advance. Regards,
Andreas

--

Dave Peterson


Dear Dave,

thank you very much for your professional help. It works. Thank you.
Regards, Andreas