Thread: InputBox that obtains Workbook, Worksheet, and Range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
J@Y J@Y is offline
external usenet poster
  
Posts: 127
Default InputBox that obtains Workbook, Worksheet, and Range
I have a macro that takes a range of cells as input. I am trying to use an
InputBox or something similiar to let the user select the range they need.
First how would I let the user select their range in the format :
'[Book1.xls]Sheet2'!$F$6:$F$10, and second how would I transform that into a
variable that's similiar to Workbooks().WorkSheets().Range()?
Reply With QuoteReply With Quote