LinkBack URL
About LinkBacks
What is this code doing?
Please Login or Register to view this content.
What is this code doing?
Please Login or Register to view this content.
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?
Nope. You need to use a different type parameter (xlcelltypeformulas)
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks