Using concatenation in a macro

[susanvkelly]

Using a macro, I format a weekly extract file that has a different number of rows every week, but the column headings stay the same.

I want to put a concatenate function into my formatting macro, but I can't predict the number of rows. How do I do this so that I can tell Excel to find the bottom of the rows (by using Ctrl-End), then take that cell identifier & use it in the macro? I want the concatenation result to be in a new column.

Hope this makes sense.
Thanks
Susan

 

[ashish mehra]

Hi,

You can use

LR = ThisWorkbook.Sheets("Sheet1").Cells(Rows.Count, 1).End(xlUp).Row

Regards,
AM