View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peter Morris Peter Morris is offline
external usenet poster
 
Posts: 13
Default syntax - range name as a variable



I can select a named range like so :

range ("range_01").select

this works. but I want to make the selected range a variable like this:

range_string = "range_01"
range (range_string).select

This gives me error messages "method range of object global failed"


What is the correct syntax for doing this?