Thread: Select range from ActiveCell do to Lastcell in ColumnA
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Aussie Bob C Aussie Bob C is offline
external usenet poster
  
Posts: 24
Default Select range from ActiveCell do to Lastcell in ColumnA
Range("A10:M" & Range("A10000").End(xlUp).Row.Cut
will cut a range from Cell A10 across to Column M and down to last cell in
Column A
How do you replace reference to Cell A10 with ActiveCell in Column A?

--
Thank you

Aussie Bob C
Little cost to carry knowledge with you.
Win XP P3 Office 2007 on Mini Mac using VMware.
Reply With QuoteReply With Quote