Fill formulas to end of column

[R1C1]

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]

See if this helps.




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

[R1C1]

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]

hello
please provide numerical example.