Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Obtaining cell reference from index function
I am attemtping to build custom screen tips for a scatter graph and already
been given some help. However I am stuck again. The following code extract myX = WorksheetFunction.Index _ (.SeriesCollection(Arg1).XValues, Arg2) ' Extract y value from array of y values myY = WorksheetFunction.Index _ (.SeriesCollection(Arg1).Values, Arg2) populates two variables (myX and myY) which correspond to the x and y values. What I am having trouble with is obtaining the cell reference to either offset from to obtain the data I wish to display in my custom screen tip. If for example, myX extracts a value from cell B3, i need to access B5 for my custom data. I must be getting close. Thanks to anyone who helps me in my (hopefully) final hurdle. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Obtaining Multiple Results Using Index/Match Functions | Excel Worksheet Functions | |||
Obtaining Multiple Results Using Index/Match Functions | Excel Worksheet Functions | |||
Obtaining Multiple Results Using Index/Match Functions | Excel Worksheet Functions | |||
Now With Index -- IF Function Does Not Work With Cell Reference | Excel Worksheet Functions | |||
Cell reference from previous index function | Excel Programming |