Find all formatted cells

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

Is there a way to do something like this code to find all formatted
cells?

Set rngData = rngRange.SpecialCells(xlFormats)

tia
 
All cells are formatted - some just have the default format.

so no, there is no specialcells for this
 
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

change all specific row references to next row available in fill downformula 2
Error on pastespecial 2
make autofill code conditional to avoid runtime error. 1
List of values / unique problem 1
Fill down Error 4
Excel macro to Automate ppt 0
VBA set thick borders around non empty cells in range 0
Error 400 in VB code execution? 1

Back
Top