Fill formulas to end of column

[R1C1]

Being a VBA noobie, ,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.

R1C1

[lior03]

hello
please provide numerical example.