View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Piers 2k Piers 2k is offline
external usenet poster
 
Posts: 11
Default Determine currently selected cells at start of macro

Hi folks,

Macro to create a chart. Works fine, except I have to use an InputBox for
the user to enter the range.

I'd prefer for the macro to determine the currently selected cells at the
start, and use that as the range. Any ideas?

Thankx in advance,
Piers