Range References in vba

  • Thread starter Thread starter Isis
  • Start date Start date
I

Isis

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
 
Try

With Sheet4

.Range(.Range("tStart"),.Range("tEnd")).Value = "Temp"
End With
 
Use a comma so seperate the names, not a colon.

Sheet4.Range("tStart","tEnd").Value = "Temp"
 
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
 
Back
Top