Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |