ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   select all arrows or lines on active worksheet - an example (https://www.excelbanter.com/excel-programming/312213-select-all-arrows-lines-active-worksheet-example.html)

DataFreakFromUtah

select all arrows or lines on active worksheet - an example
 
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. :)


All times are GMT +1. The time now is 06:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com