Took me a while but i figured it out. Thanks anyway. Got another
question for you though. How can I choose a range using vba. For
example, I know i want to start out with A1 but when i want to end the
range at Column "D" I want my function to return the value of the row.
Like:
Range A1:Dx
where x is the number returned from a function. Is that even possible
It could be anyone of these.
A1:D10
A1:D15
A1:D20
I need these for charting purposes


--
NewGuy100
------------------------------------------------------------------------
NewGuy100's Profile: http://www.excelforum.com/member.php...o&userid=27935
View this thread: http://www.excelforum.com/showthread...hreadid=475150