| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Select with Range.Cells property
Can anyone tell me why:
Range(Cells(iNameR, iNameC + 3), Cells(iNameR, iNameC + iCount + 2)).Select works while: Range(Cells(iTargetR, iTarDateC)).Select returns the runtime error '1004' method 'Range' of object '_Global' TIA -- remove 901 from reply email for valid address. ----- remove |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using Select with Range.Cells property
Assuming here that iTargetR is an integer between 1 and 65536 and iTarDateC
is an integer between 1 and 256 Try just Cells(iTargetR, iTarDateC).Select -- Rob van Gelder - http://www.vangelder.co.nz/excel " Ralph Heidecke" wrote in message news:%S0Gd.81947$8l.66029@pd7tw1no... Can anyone tell me why: Range(Cells(iNameR, iNameC + 3), Cells(iNameR, iNameC + iCount + 2)).Select works while: Range(Cells(iTargetR, iTarDateC)).Select returns the runtime error '1004' method 'Range' of object '_Global' TIA -- remove 901 from reply email for valid address. ----- remove |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using Select with Range.Cells property
Range can not take a single range object as an argument. Range(Range1) is
not legal syntax. Range(Range1,Range2) is. (Rangex represents a range object). -- Regards, Tom Ogilvy " Ralph Heidecke" wrote in message news:%S0Gd.81947$8l.66029@pd7tw1no... Can anyone tell me why: Range(Cells(iNameR, iNameC + 3), Cells(iNameR, iNameC + iCount + 2)).Select works while: Range(Cells(iTargetR, iTarDateC)).Select returns the runtime error '1004' method 'Range' of object '_Global' TIA -- remove 901 from reply email for valid address. ----- remove |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select a range of cells | Excel Discussion (Misc queries) | |||
| When entering data into a range of cells, select the entire range. | Excel Discussion (Misc queries) | |||
| select a range using "cells()" | Excel Worksheet Functions | |||
| How to select range of cells | Excel Programming | |||
| Can Range.Find search a Cells' Text property? | Excel Programming | |||
Hybrid Mode
