| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need coding to DELETE a line on a spreadsheet.
Hi
With Worksheets("SpeedPlay").Shapes.AddLine(546, 90, 546, 114) ..Line.ForeColor.RGB = RGB(0, 0, 0) End With The preceding Macro code adds a black line of a certain length and in a certain place on a spreadsheet named SpeedPlay. What I need is the coding to DELETE (remove) this same line. Is that possible? Thankyou Ed |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Challenge - Excel Line Feed Character CHR(10) - How to Delete and keep the text formatting without going ro single line in a cell ? | Excel Worksheet Functions | |||
| How do I add a line every 3 lines in a 5600 line spreadsheet? | Excel Discussion (Misc queries) | |||
| Color coding data in line graphs | Charts and Charting in Excel | |||
| COLOR CODING A PROFIT & LOSS SPREADSHEET | Excel Discussion (Misc queries) | |||
| Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
Threaded Mode
