LinkBack URL
About LinkBacks
What is this code doing?
.SpecialCells(2, 1).Areas
What is this code doing?
.SpecialCells(2, 1).Areas
The joys of lazy coding.
2 restricts the SpecialCells to constants and the 1 specifies numbers.
Everyone who confuses correlation and causation ends up dead.
Ah got it. So if it were formulas, it wouldn't read it?
Interesting question. It had never struck me before that there were numeric constants.
Furthermore they seem with the odd exception to be in the same order as you see with the F5 Goto Special functionality
i.e.
1,1 returns comments
2,1 constants
3,1 formulae
3,2 text formulae
3,3 seemingly both text and numeric formulae
3.4 logical
4,1 blanks
7,1 non blanks
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Nope. You need to use a different type parameter (xlcelltypeformulas)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks