select only cells with content

[Hein]

Hi all,

Is it possible to use the next code:

Please Login or Register  to view this content.

and then reduce the selected cells to only those that have content.

Normally the selection of an entire column is not a problem but the next step in the code is:

Please Login or Register  to view this content.

etc.

Because a lot of cells will be empty and / or have no color in it, this takes a lot of time.

Thanks in advance
Hein

[royUK]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[royUK]

You had \code instead of /code in the tags

Try this

Please Login or Register  to view this content.

[Hein]

Hallo (again!) Roy,
Thanks for your reply

I see what you mean. In fact it dawned at me while I was fetching a cup of tea that the "go-to" possibility might be a solution.

Using your code gives me error 1004: no cells are found

If I use the macro recording I get the code

Please Login or Register  to view this content.

This results in the same message/error

Thanks
Hein

PS
An other approach gives me the desired results:
I noticed that all cells contain formulas. Using the code

Please Login or Register  to view this content.

gives me the desired results
So thanks for putting me on the right track

[royUK]

It's always best to add an On error goto with SpecialCells just in case no cells match the requirements.

[Hein]

Thanks for the addition
In this case cells must change but I can use your remark in other places
Hein