Dynamic named range

[jdmc45]

Hi

How do I create a dynamic named range which I can use in an email macro so the updated range (will only change the number of rows down but not the number of columns ) can be copied and pasted into an automated email generated in outlook?

Thanks!
James

 

[dermie_72]

Use a last row variable on the column that contains the data.

LR = Cells(Rows.count, A).End(xlUp).Row

Where the column is A. Change the column to the data that suits.