Modification required in the code line which finds the Last column

Dear Friends,

I get an error message:
The Error 91 (Object variable not set) appears when executed & debugged in the following line.

Please Login or Register  to view this content.

Basically, the above line finds the last used column to execute further. In the workbook, the first column is hidden.

As my data sheet is already designed, I need to select the columns A:CY only. I don't want to extend the selection further to select the data. But Rows may vary.

Or, any other reason for the above Error?

Please help me to modify the code.

Thanks in advance.

acsishere.

Sir,

First of all, thanks a lot for your cute code for my earlier thread.
I tried to modify as you suggested to insert After:=Range($A$3) in the code.

But shows compilation error.

Any solution, Please Sir.

acsishere.