P.S. - Here's the logic I figured out by trial and error from your
code Dave:
(L/R End Point, U/D End Point, L/R Start Point, U/D Start Point)
where L/R (Left/Right) is the horizontal axis and U/D (Up/Down) is the
vertical axis.
Not sure why there was a '#' sign in the recorder code but it was n
Awesome! That did the trick Dave. Thanks!
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linke
I've been trying to use the macro recorder to capture the code on
inserting a vertical line from the Insert-->Shapes part of the menu in
Excel 2007. For some reason it appears that the recorder does not
capture drawing tools.
I want to be able to place a line through VB and control the length,
wid
