View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve C Steve C is offline
external usenet poster
 
Posts: 119
Default Setting Range Variable

I would like to set a variable equal to whatever the currently selected range
is on my spreadsheet. I have started my procedure as follows (assuming that
a given range of cells has already been selected on my spreadsheet):

Dim rng as Range
Set rng = Active range of cells currently selected

What is the code I need for describing the active range? Thanks.
--
Steve C