Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Drile
-
Group Lines in Excel?
I tryed your code but we misunderstood. Your code select the first 50 Rows on the Sheet1, but I wan't to select first 50 Lines (Shape Objects). Lines were draw with: ActiveSheet.Shapes.AddLine(BeginX, Beginy, EndX, EndY) Any suggestion? Drile- Drile
- Post #8
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Group Lines in Excel?
Thank you Skip, you relived me!- Drile
- Post #6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Group Lines in Excel?
If I summarize my problem: How should I on the most effective way select first 50 from 100 shapes (ie. lines). I can't find out the right code. Drile- Drile
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Group Lines in Excel?
Sorry to be unclear, inconcised...I hope that this code will help you: Dim n_Rows_LINE As Integer dim Group as String dim Layerji_Array() as Variant For n_Rows_LINE = 1 To 50 Group = """" & n_Rows_LINE & """" ReDim Preserve Layerji_Array(n_Rows_LINE) Layerji_Array(n_Rows_LINE) =...- Drile
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Group Lines in Excel?
Hello I already posted this problem, but I'm still struggling with my code. So I will make my problem a little different (Raypayette, thank you for you answer’s): How should I group the first 50 from 100 lines on the Sheet1. I know that I can: ActiveSheet.Shapes.Range(Array("Line 6", "Line...- Drile
- Thread
- Replies: 8
- Forum: VBA Visual Basic for Applications (Microsoft)
