| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to assign a variable in a range select
I tried to assign a variable for a cell range and it returns with an error.
Thanks. ActiveCell.Offset(0, 1).Select Range("ActiveCell.Offset(0, 0):ActiveCell.Offset(0, 4)").Select........this code does not work |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to assign a variable in a range select
ActiveCell.Offset(0, ,4).Select
-- HTH Bob Phillips "Paul" wrote in message ... I tried to assign a variable for a cell range and it returns with an error. Thanks. ActiveCell.Offset(0, 1).Select Range("ActiveCell.Offset(0, 0):ActiveCell.Offset(0, 4)").Select........this code does not work |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to assign a variable in a range select
You are soooooo close:
Range(ActiveCell.Offset(0, 0).Address & ":" & ActiveCell.Offset(0, 4).Address).Select HTH, -- George Nicholson Remove 'Junk' from return address. "Paul" wrote in message ... I tried to assign a variable for a cell range and it returns with an error. Thanks. ActiveCell.Offset(0, 1).Select Range("ActiveCell.Offset(0, 0):ActiveCell.Offset(0, 4)").Select........this code does not work |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to assign a variable in a range select
No Luck...Does not work
ActiveCell.Offset(0, 1).Select........Need this one to establish the new location Range("ActiveCell.Offset(0, 0):ActiveCell.Offset(0, 4)").Select....then I need to highlight the cell from above plus 4 cells to the right "Bob Phillips" wrote in message ... ActiveCell.Offset(0, ,4).Select -- HTH Bob Phillips "Paul" wrote in message ... I tried to assign a variable for a cell range and it returns with an error. Thanks. ActiveCell.Offset(0, 1).Select Range("ActiveCell.Offset(0, 0):ActiveCell.Offset(0, 4)").Select........this code does not work |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to assign a variable in a range select
Thanks...It is working
"George Nicholson" wrote in message ... You are soooooo close: Range(ActiveCell.Offset(0, 0).Address & ":" & ActiveCell.Offset(0, 4).Address).Select HTH, -- George Nicholson Remove 'Junk' from return address. "Paul" wrote in message ... I tried to assign a variable for a cell range and it returns with an error. Thanks. ActiveCell.Offset(0, 1).Select Range("ActiveCell.Offset(0, 0):ActiveCell.Offset(0, 4)").Select........this code does not work |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to assign a variable in a range select
Another way...
activecell.resize(1,5).select Paul wrote: I tried to assign a variable for a cell range and it returns with an error. Thanks. ActiveCell.Offset(0, 1).Select Range("ActiveCell.Offset(0, 0):ActiveCell.Offset(0, 4)").Select........this code does not work -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select a variable range | Excel Worksheet Functions | |||
| Use a Variable to select a range | Excel Discussion (Misc queries) | |||
| How can I assign a range starting cell based on a variable locati. | Excel Discussion (Misc queries) | |||
| How can I assign a range starting cell based on a variable locati. | Excel Worksheet Functions | |||
| Range.Select with variable cells ? | Excel Programming | |||
Linear Mode
