Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I have the following code: Code: -------------------- With Worksheets("Sheet1").Shapes("Text1").Line .ForeColor.SchemeColor = 26 .Weight = 2 End With With Worksheets("Sheet1").Shapes("Text2").Line .ForeColor.SchemeColor = 26 .Weight = 2 End With -------------------- As you can see, I am doing the same thing with both Shapes("Text1") and Shapes("Text2"). How do I combine the 2 With Statements above without physically grouping the items on the drawing toolbar? Thanks in advance! -- grime ------------------------------------------------------------------------ grime's Profile: http://www.excelforum.com/member.php...o&userid=19227 View this thread: http://www.excelforum.com/showthread...hreadid=507907 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help displaying "Maximum" or "Minimum" if cell is max or min in a group? | Excel Discussion (Misc queries) | |||
How do i enable "Group" & "Ungroup" in a protected sheet | Excel Discussion (Misc queries) | |||
=IF(VLOOKUP(C11,Group,2,FALSE)=D11,"True","Not Valid") and =IF(D1 | Excel Worksheet Functions | |||
How do i enable "Group" & "Ungroup" in a protected sheet | Excel Discussion (Misc queries) | |||
Pivot table "Group and Show Details" vs. "SubTotals" | Excel Programming |