reading named cell in vba

[avmeno]

i am working with a macro that will produce a custom chart -- i am reading the location of the first cell in the range from screen. I then want to input series in adjacent cells as source for chart -- how do i do this?

Example: if i read a1 as the location of my first cell in range my chart has three series b1:b5, d1:d13, f1:f5 -- if i read d10 as my first cell in range then my chart has three series e10:e15,g10:g23,h10:h15 how do i incorporate to the source for chart ?

 

[johnwm]

Hi avmeno, and welcome to Tek-Tips.

To get the best from the forums, please read faq222-2244. You will find you get better answers to VBA questions in the VBA forum, rather than here, which is the VB5/6 forum. Try forum707

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

http://www.essexsteam.co.uk

for steam enthusiasts