Thread: VBA Dynamic Selection
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AJMorgan591 AJMorgan591 is offline
external usenet poster
  
Posts: 1
Default VBA Dynamic Selection

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 :)


--
AJMorgan591
------------------------------------------------------------------------
AJMorgan591's Profile: http://www.excelforum.com/member.php...o&userid=27774
View this thread: http://www.excelforum.com/showthread...hreadid=473647

Reply With QuoteReply With Quote