Thread: Asking for a group of cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
david mcritchie david mcritchie is offline
external usenet poster
  
Posts: 691
Default Asking for a group of cells
Hi Max,
I would have the InputBox use a default of the
activecell or the current selection.

See webpage:
InputBox and MsgBox
http://www.mvps.org/dmcritchie/excel/inputbox.htm

and the specific example:
Multiple Range Selection in InputBox (#multi)
http://www.mvps.org/dmcritchie/excel/inputbox.htm#multi
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm



Reply With QuoteReply With Quote