shadow12345
Well-known Member
- Joined
- May 10, 2004
- Messages
- 1,238
Hi,
I use a macro to update a number of charts. I have set my series up with the $ in front of them yet for some reason they occasionally change (must be something in the ranges or code somewhere but its to complex)
My question is.... can I have VBA check all my series and ensure they are all looking in the correct range. If the label is in column A the data is column B if the label is in L the data is in M and so on.
Can I do that? (the row refs are find so its only the columns i need to check)
I use a macro to update a number of charts. I have set my series up with the $ in front of them yet for some reason they occasionally change (must be something in the ranges or code somewhere but its to complex)
My question is.... can I have VBA check all my series and ensure they are all looking in the correct range. If the label is in column A the data is column B if the label is in L the data is in M and so on.
Can I do that? (the row refs are find so its only the columns i need to check)
