Range.

Nigel Martin · Apr 25th, 2002, 08:07 AM

I have a macro which makes takes excel to an unspecified that it works out but then I wnat it to go 14 columns to the right on the same row then selct the next 3 cell to the right ie goto O14 (active cell) then select O14 through P145. Any ideas ?

jrnyman · Apr 25th, 2002, 08:12 AM

"I have a macro which makes takes excel to an unspecified that it works out but then I wnat it to go 14 columns to the right on the same row then selct the next 3 cell to the right ie goto O14 (active cell) then select O14 through P145. Any ideas ?"

Not sure what you want, but give this a go:

FirstOne = ActiveCell.Offset(0,14).Address
LastOne = ActiveCell.Offset(0,16).Address
Range(FirstOne & ":" & LastOne).Select

Nigel Martin · Apr 25th, 2002, 08:21 AM

Just what the doctor ordered.
Many thanks.

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

Apr 25th, 2002, 08:07 AM	#1
Nigel Martin Board Regular Join Date: Feb 2002 Posts: 133	I have a macro which makes takes excel to an unspecified that it works out but then I wnat it to go 14 columns to the right on the same row then selct the next 3 cell to the right ie goto O14 (active cell) then select O14 through P145. Any ideas ?

Apr 25th, 2002, 08:12 AM	#2
jrnyman Board Regular Join Date: Mar 2002 Location: Boston, MA Posts: 105	"I have a macro which makes takes excel to an unspecified that it works out but then I wnat it to go 14 columns to the right on the same row then selct the next 3 cell to the right ie goto O14 (active cell) then select O14 through P145. Any ideas ?" Not sure what you want, but give this a go: FirstOne = ActiveCell.Offset(0,14).Address LastOne = ActiveCell.Offset(0,16).Address Range(FirstOne & ":" & LastOne).Select

Apr 25th, 2002, 08:21 AM	#3
Nigel Martin Board Regular Join Date: Feb 2002 Posts: 133	Just what the doctor ordered. Many thanks.