2010 Macro - insert file name into column, variable rows

[Scalpel4]

This forum has helped me build a good macro script, but I have one than I'm having trouble putting together.

I have a spreadsheet, new one each day, that I need to add in the workbook name into each row. The number of rows vary.

I think I can use this to add in the file name for a defined range but I'm having trouble putting this all together, especially since the number of rows will vary each day.

Range("L2:L999").Value = ActiveWorkbook.FileName

Any recommendations?

[PCI]

Assuming D is a column which can be used to know where is the last row used, try

Please Login or Register  to view this content.

else send an example

[Scalpel4]

Perfect PCI, thank you!