Select range from ActiveCell do to Lastcell in ColumnA
in [Programming]
|
From: Aussie Bob C on 15 Mar 2010 18:31 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.
|
Pages: 1 Prev: How to use structured reference (ListColumns) in VBA Next: active worksheet |