Cells.SpecialCells: Do you use it much?

B

bill

Well-known Member
Joined
Mar 7, 2002
Messages
550
Hello,
Saw this in some of the threads here on MrExcel and I don't have any familiarity with it.

Do you find yourself using it a lot and if so, how does it make your life/coding easier?

thx!
 
Sort by date Sort by votes
Very well. (subject to a limitation of 8192 discrete areas)
 
Upvote 0

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
Meaning that SPECIALCELLS will treat HIDDEN (height / width = 0) and AUTOFILTERED (not visible) the same?
 
Upvote 0
bill said:
Meaning that SPECIALCELLS will treat HIDDEN (height / width = 0) and AUTOFILTERED (not visible) the same?
Click to expand...

Yep - only looks at visible ones (assuming you are using xlcelltypevisible)
 
Upvote 0
You must log in or register to reply here.

Similar threads

Sweedler
  • Solved
Formula to show if Tab is hidden or not
Replies
4
Views
302
Fluff
Fluff
zoharb
  • Question
more Question to the thread-Using IFS to calculate a task due by date but needing to remove weekends
Replies
0
Views
66
zoharb
zoharb
M
  • Question
Sumif problem
Replies
2
Views
181
Special-K99
S
C
  • Question
Compare cells in rows from 2 differents sheets before copy
2
Replies
15
Views
426
Tupe77
T
SeniorNewbie
  • Solved
How to modify an existing line in a codemodule?
Replies
1
Views
63
SeniorNewbie
SeniorNewbie

Forum statistics

Threads
1,216,049
Messages
6,128,496
Members
449,455
Latest member
jesski

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top