Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range References in vba
I have 2 named cells say, tStart and tEnd - If I wanted to set the
contents of all cells within the Range("tStart:tEnd") I thought I could do something like the following; Sheet4.Range("tStart:tEnd").Value = "Temp" but that givs me a '400' type error - what would the way be to reference these cells. On a side issue, is it possible to get cell references from a named cell/Range in some way ? Thanks for any illumination Regards |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Offset vs. Range references | Excel Programming | |||
Relative range references in VBA - how? | Excel Programming | |||
Range references in VB | Excel Programming | |||
How to rename references from range names to cell references | Excel Discussion (Misc queries) | |||
Column and row references of range | Excel Programming |