PDA

View Full Version : Solved: Fill formulas to end of column



R1C1
04-03-2006, 08:26 AM
Being a VBA noobie, :banghead: ,I am having trouble with the following:

Column length for "S:S: varies with spaces between lists
Formulas in ("T8:Z8") are constant
I need the formulas in ("T8:Z8") to fill, down through their respective columns, through the last entry in column "S:S", including the spaces between lists in "S:S".

Can anyone help a noobie?
Many, many, thanks if you can! :)

R1C1

Shazam
04-03-2006, 08:33 AM
See if this helps.




Range("T8:Z" & Cells(Rows.Count, "S").End(xlUp).Row).FillDown
Application.CutCopyMode = False

R1C1
04-03-2006, 08:47 AM
And Shazam, it is done. Thank you so much. With your quick post to my problem, I see I have a lot to learn. :stars:

R1C1 :clap2:

lior03
04-03-2006, 12:17 PM
hello
please provide numerical example.