Need to change var code to a dynamic range

[Grahamfeeley]

Hi Guys once again I am seeking your help.
I have this code which uses a range hard coded
I wish to be able to make it dynamic as the rows in column A change daily

Please Login or Register  to view this content.

I tried but really need your help
Thanks in Advance

[Richard Buttrey]

Why not just create a dynamic range name in Excel and use the name in your macro?

Not entirely sure what your range is but in extremis if it were a varying number of rows and column with A1 as the topmost left cell then

Please Login or Register  to view this content.