| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range Select
When I use something similiar to "Range(activecell.offset(5,1)).select" it
doesn't work. What do I need to do to select a single cell using Range? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Range Select
You are very close:
ActiveCell.Offset(5,1).Select you don't need the Range() function because ActiveCell is already a range. -- Gary''s Student - gsnu200764 "ranswert" wrote: When I use something similiar to "Range(activecell.offset(5,1)).select" it doesn't work. What do I need to do to select a single cell using Range? Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Range Select
Thanks that helps
"Gary''s Student" wrote: You are very close: ActiveCell.Offset(5,1).Select you don't need the Range() function because ActiveCell is already a range. -- Gary''s Student - gsnu200764 "ranswert" wrote: When I use something similiar to "Range(activecell.offset(5,1)).select" it doesn't work. What do I need to do to select a single cell using Range? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can change range to select active rows instead of :=Range("S10 | Excel Discussion (Misc queries) | |||
| Find End in Undefined Range Select Range Trim | Excel Programming | |||
| When entering data into a range of cells, select the entire range. | Excel Discussion (Misc queries) | |||
| Compare a selected Range with a Named range and select cells that do not exist | Excel Programming | |||
| Select Sheet then Select Range | Excel Programming | |||
Linear Mode
