pb in macro with "Range"

sticky · May 20th, 2002, 03:00 AM

Hello!
I want to make a macro to construct 120 radar graphs. The data are from cell (1,1) to cell(120, 5). I have 120 regions and five axes. I would like to use the command "for", but I do not succeed in selecting the range. He does not understand

for i=1 to 120
range(cells(i,1), cells(i,5)).selection

What can I do?

Mudface · May 20th, 2002, 03:23 AM

Not exactly sure if this is what you want, but it will select all the cells from 1,1 to 120,5: -

Range(Cells(1, 1), Cells(120, 5)).Select

sticky · May 20th, 2002, 05:33 AM

not exactly, but it could help
thanks

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

May 20th, 2002, 03:00 AM	#1
sticky New Member Join Date: May 2002 Location: France Posts: 8	Hello! I want to make a macro to construct 120 radar graphs. The data are from cell (1,1) to cell(120, 5). I have 120 regions and five axes. I would like to use the command "for", but I do not succeed in selecting the range. He does not understand for i=1 to 120 range(cells(i,1), cells(i,5)).selection What can I do?

May 20th, 2002, 03:23 AM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Not exactly sure if this is what you want, but it will select all the cells from 1,1 to 120,5: - Range(Cells(1, 1), Cells(120, 5)).Select

May 20th, 2002, 05:33 AM	#3
sticky New Member Join Date: May 2002 Location: France Posts: 8	not exactly, but it could help thanks