Code That Selects all non blank cells...Clarification needed.

[swade730]

Hello

below is the following code that I am having confusion with understanding

Please Login or Register  to view this content.

This code selects all the non blank cells in the active worksheet...
But as you can see in my comment, I do not understand why this code has the number 23 in it.
and further more, Why is it using the union approach?

Will this work for any range of data?
What if I wanted to do the reverse and select all the blank cells or cells with specific criteria? Where in this code would I make those adjustments?

Attached is my spreadsheet where I just entered letters into random text in different cells on sheet1 to verify the code work.

Any elaboration on this what seems to be important code would be of great help.

Thank You!

[HaHoBe]

Hi, swade730,

both formulas and constants have certain values assigned:

xlErrors 16
xlLogical 4
xlNumbers 1
xlTextValues 2

If you add up the values you will get - ?

Union is for both kind of cells which may be listed in a worksheet: formulas and constants. The unions makes it one big range to work on.

xlCellTypeBlanks is only for empty cells.

Maybe install the VBA help or have a look at the Object Browser for more info on these constants.

Ciao,
Holger