A
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
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