Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic Row Selection
I'm trying to select rows based on a parameter passed to the sub procedure that selects the row. I know if I want a set row then I could do: Rows(6:6).Select However, let's say I have a parameter r that contains the row number I want to select. I tried: Rows(r.Value + ":" + r.Value).Select However, this just gives me an error. Any help would be appreciated. Thanks! - Bruce *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic Row Selection
try
Rows(r.Value + ":" + r.Value).Select Rows(r & ":" & r).Select -- Don Guillett SalesAid Software Granite Shoals, TX "Bruce B" wrote in message ... I'm trying to select rows based on a parameter passed to the sub procedure that selects the row. I know if I want a set row then I could do: Rows(6:6).Select However, let's say I have a parameter r that contains the row number I want to select. I tried: Rows(r.Value + ":" + r.Value).Select However, this just gives me an error. Any help would be appreciated. Thanks! - Bruce *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic Row Selection
rows(6).Select
works as well, rw = 6 rows(rw).Select Regards, Tom Ogilvy "Bruce B" wrote in message ... I'm trying to select rows based on a parameter passed to the sub procedure that selects the row. I know if I want a set row then I could do: Rows(6:6).Select However, let's say I have a parameter r that contains the row number I want to select. I tried: Rows(r.Value + ":" + r.Value).Select However, this just gives me an error. Any help would be appreciated. Thanks! - Bruce *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic Row Selection
What's the data type of r.value? Was the error a 1004?
-----Original Message----- I'm trying to select rows based on a parameter passed to the sub procedure that selects the row. I know if I want a set row then I could do: Rows(6:6).Select However, let's say I have a parameter r that contains the row number I want to select. I tried: Rows(r.Value + ":" + r.Value).Select However, this just gives me an error. Any help would be appreciated. Thanks! - Bruce *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic Row Selection
The variable was an integer. I think the first two replies should work. Thanks for the help! - Bruce *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range Selection Using VBA | Excel Discussion (Misc queries) | |||
SUBTOTAL - dynamic selection | Excel Worksheet Functions | |||
Need Help on Dynamic Range Selection | Excel Discussion (Misc queries) | |||
dynamic selection of cells | New Users to Excel | |||
Macro - Dynamic cell selection | Excel Discussion (Misc queries) |