Select non-empty cell range with VBA

[mexykanu]

Hello,

First of all i want to thank the people that helped me with my previous question.

I would like to ask for help with the following issue - i have three columns that look like this:
1.png
Which should have a selection around them like this:
2.png

The macro should ignore rows that do not contain values in all of the three columns.

Unfortunately i do not know VBA, i have searched for this issue on Google and found some information but i cannot put them together.
For exemple:
http://www.mrexcel.com/archive/VBA/21407.html
http://stackoverflow.com/questions/8...excel-with-vba

Thank you for your time.
Daniel.
issue2.xlsm

[HerryMarkowitz]

Try following code..

Please Login or Register  to view this content.

[mexykanu]

Try following code..

Please Login or Register  to view this content.

Thank you, but i have found two issues:
- i cannot copy the cells via Copy and Paste.
- rows that do not have values on all columns are selected; the selection should look like in the attached picture: Attachment 282782

[HerryMarkowitz]

Sorry, but your explanation is very complicated for me...
Make more clear explanation.
Best regards.

[venkatpvc]

Please Login or Register  to view this content.

this above code do what your looking for

[mexykanu]

Sorry, but your explanation is very complicated for me...
Make more clear explanation.
Best regards.

Sorry, but your explanation is very complicated for me...
Make more clear explanation.
Best regards.

Hello,

I have attached a picture. 3.png

Thank you!

Please Login or Register  to view this content.

This worked perfectly. Thank you !

[venkatpvc]

so did you get what you need ?

[mexykanu]

so did you get what you need ?

Yes the code works perfectly. Thank you very much.

[venkatpvc]

glad i could help please mark thread as SOLVED
Please Add my REP.

Thank you,

[mexykanu]

Yes, of course!