Select range starting from ActiveCell

Bukol · Apr 4th, 2002, 09:24 AM

I am using Excel 2000.
I am trying to write code for selecting a range for copy and paste, starting from the active cell 3 columns right and 4 rows down.
That should be an easy one? No?
Hans

AJ · Apr 4th, 2002, 09:32 AM

How about this:

Range(ActiveCell, ActiveCell.Offset(3, 2)).Select

Is that what you meant?

Rgds
AJ

Al Chara · Apr 4th, 2002, 09:33 AM

Try the following:

Range(Selection, Selection.Offset(4, 3)).Copy

Bukol · Apr 4th, 2002, 09:37 AM

Guys,
That's exactly what I meant.
Thanks again.
Hans

Apr 4th, 2002, 09:33 AM	#3
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Try the following: Range(Selection, Selection.Offset(4, 3)).Copy __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 4th, 2002, 09:24 AM	#1
Bukol Board Regular Join Date: Mar 2002 Location: Philippines Posts: 55	I am using Excel 2000. I am trying to write code for selecting a range for copy and paste, starting from the active cell 3 columns right and 4 rows down. That should be an easy one? No? Hans

Apr 4th, 2002, 09:32 AM	#2
AJ Board Regular Join Date: Mar 2002 Location: =ActiveCell.Address Posts: 478	How about this: Range(ActiveCell, ActiveCell.Offset(3, 2)).Select Is that what you meant? Rgds AJ

Apr 4th, 2002, 09:37 AM	#4
Bukol Board Regular Join Date: Mar 2002 Location: Philippines Posts: 55	Guys, That's exactly what I meant. Thanks again. Hans