Running For Each-Next on Visible Cells Only

  • Thread starter Thread starter Dan Gesshel
  • Start date Start date
D

Dan Gesshel

Hello.

I would like to run a For Each - Next loop on only visible cells in a range.
The range may or may not be filtered by the user. If it is filtered, I don't
want the loop to run on those cells that have been hidden.

So for example I have:

For Each Cells in MyRange
'code here
Next Cell

What do I need to put in this statement so it only looks for the visible
cells? Or is there something else I should be doing when declaring MyRange?
Anyone out there that can help me would be great.

Thanks.

Dan
 
Dan,

Try something like the following

Dim Rng As Range
For Each Rng In Range("MyRange").SpecialCells(xlCellTypeVisible)
Debug.Print Rng.Address
Next Rng


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
what wrong here, range Cell as counter 6
Create Sheets from a Range and Copy Data on copy Data on newlycreated Sheets with the Sheet Names 2
For each Next Loop 7
Code to delete names works in one WB, but not another WB? 2
vba array logic 3
For Each Next 16
Lookup Data in external workbook 3

Back
Top