VBA Dynamic Selection

[AJMorgan591]

Hi all,

Long story short, is it possible in VBA to dynamically select cells in the range (for example) A1:Mx where x = the last row that contains data (i.e. non-blank cells). The blank cells (i.e. those cells after row x) do contain formulas linked to other worksheets but if the relevant cells in those other worksheets are blank then so too are these cells.

Thanks in advance