Hi there,

The Selection.Address will give you a reference to the current selection as
a string.

Shafiee.

"Piers 2k" wrote in message
...
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