Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting Variable Rows
Hello,
I am attempting to get some code to work that looks like: X = X + 95 Y = Y + 95 Rows("X:Y").Select Basically I need to to be able to change the values of the rows I need to select. I cant find anything in help, so could someone help me with the syntax. Thanks Matt D. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting Variable Rows
Hi Matt
Try this Rows(X & ":" & Y).Select -- Regards Ron de Bruin http://www.rondebruin.nl "Matt D." wrote in message ... Hello, I am attempting to get some code to work that looks like: X = X + 95 Y = Y + 95 Rows("X:Y").Select Basically I need to to be able to change the values of the rows I need to select. I cant find anything in help, so could someone help me with the syntax. Thanks Matt D. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting Variable Rows
X = X + 95
Y = Y + 95 Rows(X & ":" & Y).Select -- Regards, Tom Ogilvy "Matt D." wrote in message ... Hello, I am attempting to get some code to work that looks like: X = X + 95 Y = Y + 95 Rows("X:Y").Select Basically I need to to be able to change the values of the rows I need to select. I cant find anything in help, so could someone help me with the syntax. Thanks Matt D. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting Variable Rows
Just two other ideas. If X is always less than Y:
Rows(X).Resize(Y - X + 1).Select If not, than another idea: Range(Cells(X, 1), Cells(Y, 1)).EntireRow.Select Dana DeLouis "Matt D." wrote in message ... Hello, I am attempting to get some code to work that looks like: X = X + 95 Y = Y + 95 Rows("X:Y").Select Basically I need to to be able to change the values of the rows I need to select. I cant find anything in help, so could someone help me with the syntax. Thanks Matt D. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting Variable Data Ranges | Excel Discussion (Misc queries) | |||
Selecting a row with a variable ? | Excel Programming | |||
Selecting Variable Row Range w/Macro | Excel Programming | |||
Selecting rows with variable | Excel Programming | |||
Selecting a Range Using a Variable | Excel Programming |