View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Isis[_2_] Isis[_2_] is offline
external usenet poster
 
Posts: 51
Default 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