View Single Post
 
Old 02-21-2017, 08:50 PM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default

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)
Reply With Quote