Hi
try something like
LastRow = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).row

--
Regards
Frank Kabel
Frankfurt, Germany


Newbie wrote:
Hi,

I have some code that imports a text file into a template. In colums
F-I there are some formulaes that I need to copy down to the last row
of the imported text file. The last row can change everytime the
file is imported.

How can I find which row is the last row and then copy the formulaes
down?