'Draw ' a line

  • Thread starter Thread starter Linda
  • Start date Start date
Linda,

Display the Drawing toolbar and choose the Line tool, and draw
the line directly on the worksheet. If you want a VBA solution,
use code like the following:

Dim WS As Worksheet
Set WS = ActiveSheet
WS.Shapes.AddLine beginx:=Range("C3").Left,
beginy:=Range("C3").Top, _
endx:=Range("G3").Left, endy:=Range("G3").Top



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
...Either vertical or horizontal.

Just an added tip:
Hold the Shift key down while you drag your new line to snap it into a more
Vertical or Horizontal position.

HTH
Dana DeLouis
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i get straight lines in Power Point 2007 3
How to draw a straight line 2
Problem making line horizontal 1
Is there a way to automatically insert vertical lines 2
Horizontal Line 1
horizontal display vs Vertical 1
Typing "..." gives me a verticle line. how do i disable this? 1
Excel 2007 drawing selection tool 5

Back
Top