| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable in Range statement
Hi. I have the variable "x" which returns the row number
of the activecell. I would like to set "myrange" to be equal to the range C26 to Y of the active row. Can someone show me how to write the range statement using the variable x? myrange = range(C26:Y .... what do I put here?) Thanks, Mike. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Variable in Range statement
set myrange = range("C26:Y" & x)
tim "Mike" wrote in message ... Hi. I have the variable "x" which returns the row number of the activecell. I would like to set "myrange" to be equal to the range C26 to Y of the active row. Can someone show me how to write the range statement using the variable x? myrange = range(C26:Y .... what do I put here?) Thanks, Mike. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Variable in Range statement
Thanks, Tim
-----Original Message----- set myrange = range("C26:Y" & x) tim "Mike" wrote in message ... Hi. I have the variable "x" which returns the row number of the activecell. I would like to set "myrange" to be equal to the range C26 to Y of the active row. Can someone show me how to write the range statement using the variable x? myrange = range(C26:Y .... what do I put here?) Thanks, Mike. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Variable statement | Excel Discussion (Misc queries) | |||
| if than statement has too many variable | New Users to Excel | |||
| Problem trying to us a range variable as an array variable | Excel Programming | |||
| Case statement in variable range | Excel Programming | |||
| Passing a variable to a range statement | Excel Programming | |||
Linear Mode
