using pre-selected cells in my own chart macro
 

Question

I am writing a VB macro for excel to set up specific charts. All I nee
to know is how to select some cells in my sheet with the mouse (mor
than one cell) so when I run my chart macro the data it plots is th
values of the cells I have selected. This is trivial for one cell sinc
I can use the ActiveCell command but this does not work for more tha
one cell. I want to do this so I don't have to keep editing my macro t
place the cells I want to plot.

There must be a way of doing it since the built in chart function i
excel lets the user select cells before hand.

Any help would be much appreciated.

Gauss197

--
gauss197
-----------------------------------------------------------------------
gauss1976's Profile: http://www.excelforum.com/member.php...fo&userid=3658
View this thread: http://www.excelforum.com/showthread.php?threadid=56327