I need to find the X, Y coordinates of the from and to points of a drawn line in a spreadsheet using VBA. The basic problem is that I have saved a name for the line using the coordinates when it was created but now when the line is selected by the user I need to determine the name but to do that I need the coordinates. Any help would be greatly appreciated.
For a positive slope line:
But - you can get the name(also in the code).
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks