Help for marco to autofill in down the row

[S Himmelrich]

I've found a solution for the above topic here:
http://groups.google.com/group/micr...ove+if+current+cell+is+blank#8156eb8a4439d580


however the instruction on using the F5 is not clear to me and is not
working for me. Can anyone clarify this for me?

 

[Don Guillett]

I didn't look at the link but f5>goto>SPECIAL>>

 

[S Himmelrich]

F5 > Special, then what...?

 

[S Himmelrich]

thank you for your response.
F5, special - then what....I've seen similar postings, but I'm not
clear on what to do next.

Scott

 

[Gord Dibben]

Select the column.

F5>Special>Blanks>OK

Type an = sign in the active blank cell then arrow up or point to cell above.

Hit CTRL + ENTER keys.

With the column still selected, copy then paste special(in place)>values>ok>esc

You're done.


Gord Dibben MS Excel MVP