Yeah, I just got it from the macro recorder. I didn't play with it.
Dave.
> Date: Fri, 23 Jul 2010 04:44:33 -0700
> Subject: Re: $$Excel-Macros$$ Inserting a Vertical Line
> From: steve.slec...@gmail.com
> To: excel-macros@googlegroups.com
>
> P.S. - Here's the
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
Hi,
When I tried it in XL2003, the macro recorder gave:
ActiveSheet.Shapes.AddLine(431.25, 188.25, 678#, 423.75).Select
Try pasting that into xl2007 and see what you get.
Regards - Dave.
> Date: Thu, 22 Jul 2010 09:07:29 -0700
> Subject: $$Excel-Macros$$ Inserting a Vertical
