Thread: select range and put range address in variable
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_5_] Jim Thomlinson[_5_] is offline
external usenet poster
  
Posts: 486
Default select range and put range address in variable
Try the RefEdit Control. It should be one of the standard controls in you VBA
toolbox. It is used for selecting ranges...
--
HTH...

Jim Thomlinson


" wrote:

Through a command button in a user form, I want to ask a user to select
a group of cells(range). The user selects the cells. I would like to
retrieve the address of that range and place it in a variable.
Mary


Reply With QuoteReply With Quote