Highlight the 1st NonBlank Cell upto the last NonBlank

Hi Everyone,

Hope someone could assist me on this.

I have columns A to H with every cell on it have a data. The 1st row are for the title head.

What I need is to highlight the First cell which is A2 up to the last cell of Column H.



Thank you in advance

Sorry buddy, what I meant is to highlight the cell because I am going to copy it on other column.

So on your code? will I just put .SELECT after rg? tnx tnx



WoaaaHhh.... it works This will really be useful on my next code to be creation... instead of XL DOWN... ehehhe

Thank you so much

Thanks again ^_^ im starting to learn day by day because all of you guys...