Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help in using an Offset in a .Range().Select
I am trying to Select a Range of cells where the last cell is calcualted and will be plugged in at run time. worksheets.Range("A1:C1").Select ' This works of course, selecting A1 to C1 but I wanted the ending cell to be calculated. worksheets.Range("A1", Range("A1").Offset(colTOright)).Select Where colTOright will be calculated earlier. I tried just plugging in a number for colTOright but get an VBScript runtime error, Type mismatch: 'Range' Is there another way? Thanks Robert -- roblo ------------------------------------------------------------------------ roblo's Profile: http://www.excelforum.com/member.php...o&userid=22469 View this thread: http://www.excelforum.com/showthread...hreadid=399231 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with Range.Cells.Offset and Range.Cells( row + offset, column) | Excel Programming | |||
Select row (with offset) from VB formula result | Excel Programming | |||
How to Select a relative range with Using "Find" and Offset() | Excel Discussion (Misc queries) | |||
Select Range - using Offset ( 40 ,0 ) - not working | Excel Programming | |||
Select and Copy Range using Offset | Excel Programming |