View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jean-Yves[_2_] Jean-Yves[_2_] is offline
external usenet poster
 
Posts: 253
Default a reminder, please - Range w/out qualified reference

Hi Joe,

Not always. If rangeName refers to a range NAME, it can be on another
worksheet.
If it is only a string variable which represent a range address, then we
assume it is in the
the active sheet.
Regards,

Jean-Yves


"Joe" wrote in message
...
If I see the following in a line of code:

Range(rangeName) = Int(iValue)

Can I assume that this refers to a range in the activesheet?

Joe