Thread: Setting A Range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
reggie reggie is offline
external usenet poster
 
Posts: 30
Default Setting A Range

Is is possible to to set a range in VB and have any sub use it? If so how
would i be able to do this? Code so far

Set plane = Worksheets("Sheet1").Range("A98")

i want the range "plane" to be used throughout the worksheet.