Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
No question here, just a procedure for the archive.
Search criteria: select all arrows select arrows select all lines select lines select specific objects select specific shapes select specific alternative to AutoShapeType Property DrawingObjects msoShapeLeftArrow msoShapeRightArrow Sub ArrowsOrLinesInActiveSheetSelect() ' 'Selects all Lines (including Arrows) in active sheet ' On Error Resume Next ActiveSheet.Lines.Select 'other VBA code here End Sub p.s. I know this is a simple procedure, but it took me a few hours to realize that the solution was just too simple. :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Row select mode to highlight active row of active cell | Excel Discussion (Misc queries) | |||
How can I select the arrows in my spreadsheet? | Excel Worksheet Functions | |||
how to select cells with keyboard if the arrows don't let you go out of the formula | Excel Worksheet Functions | |||
select lines from multiple worksheets and write to new worksheet | Excel Worksheet Functions | |||
Why are Excel 2003 chart arrows and lines invisible with little c. | Charts and Charting in Excel |