Select non-empty cell range with VBA

Originally Posted by venkatpvc

so did you get what you need ?

Yes the code works perfectly. Thank you very much.