MrExcel.com - Your One Stop for Excel Tips & Solutions

Select from a common row between 2 columns

Posted by Tan Le on October 03, 2001 12:29 PM

Hello all Excel masters!

Range(Selection, Selection.End(xlUp)).Select
Range(Selection, Selection.End(xlUp)).Copy
Range(Selection, Selection.End(xlUp)).PasteSpecial paste:=xlValues


The above can select 1 column upward from a row. How do I select between column C and AB from row 200 to 1?

Best regards,
Tan Le

Posted by Barrie Davidson on October 03, 2001 12:39 PM

Tan, assuming your selection is C200, change your code to this.

Range(Selection.Address & ":AB" & Selection.End(xlUp).Row).Select
Selection.Copy
Selection.PasteSpecial Paste:=xlValues


Regards,
BarrieBarrie Davidson

Posted by Tan Le on October 03, 2001 5:37 PM

thank YOU! it works.