Range References in vba
Use a comma so seperate the names, not a colon.
Sheet4.Range("tStart","tEnd").Value = "Temp"
--
Best Regards,
Luke M
"Isis" wrote in message
...
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
|