G
Guest
I want to fill all the blank cells with 0 without having to copy and paste 100+ times. I tried "IF" function, but must not be entering it correctly as I can't get it to work.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
pfsardella
For each rngB in Selection.SpecialCells(xlCellTypeBlanks)
rngB.Value=0
Next rngB
HTH
Paul
rngB.Value=0
Next rngB
HTH
Paul
K
Ken Wright
No need for code - Select the entire range, do Edit / Go To / Special / Blanks,
then type 0 and hit CTRL+ENTER.
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03
----------------------------------------------------------------------------
Newsgroups - Where you really can get a free lunch!!
----------------------------------------------------------------------------
can't get it to work.
then type 0 and hit CTRL+ENTER.
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03
----------------------------------------------------------------------------
Newsgroups - Where you really can get a free lunch!!
----------------------------------------------------------------------------
100+ times. I tried "IF" function, but must not be entering it correctly as ICheri said:I want to fill all the blank cells with 0 without having to copy and paste
can't get it to work.
R
Ralph Winchell
It's not necessary to go through the Edit / Go To... steps. Selecting a
range, typing 0 and hit CTRL-ENTER is sufficient.
range, typing 0 and hit CTRL-ENTER is sufficient.
V
Vasant Nanavati
That won't work; only blanks need to be selected, which is the reason for
the Edit | GoTo.
the Edit | GoTo.
R
Ralph Winchell
Ahhh, I didn't see that part of the requirement.