Range References in vba
hi
on the side issue, something like this might work
MsgBox Range("tStart:tEnd").Address
or for a range
MsgBox Range("myRange").Address
regards
FSt1
"Isis" wrote:
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
.
|