|
|
#2
02-21-2017, 08:50 PM
|
|||
|
|||
Hello wlcdo2
I suggest using Option Explicit at the top of your code modules. Using the same range for the loop and CountIf your If statement will always be >0. Believe you need to specify the shape type (or name) as well, something like .Shapes("Rectangle " & rngList).Visible = True Last edited by NoSparks; 02-21-2017 at 09:26 PM. Reason: added (or name) 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Copy Excel Range and Paste in PowerPoint Shapes
|
leops | PowerPoint | 4 | 08-31-2017 06:47 AM |
| How to Hide/Un-hide a worksheet based on cell on another sheet. | easton11 | Excel Programming | 1 | 06-02-2015 12:07 PM |
|
copy a range including shapes
|
Marcus | Excel Programming | 8 | 08-17-2012 01:50 AM |
| Loop through folder of workbooks and copy range to other workbook | Snvlsfoal | Excel Programming | 3 | 07-29-2011 05:55 AM |
| PP 2010 .avi file plays during slide show, but causes the slide show to loop to begin | VictorS | PowerPoint | 0 | 10-16-2010 10:23 AM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode