Using current.region less 1 column

How can I use this code but tell it to select all but the right-most column?

Why?

I have this piece of code...

Please Login or Register  to view this content.

which puts the results in L2.

The code below must come after the code above. So If I leave it as is, the code below then selects column L as part of the print area, which I don't want.

Please Login or Register  to view this content.

Thanks much

If you leave Col L blank and place the result in say M2 then you wouldn't have a problem e.g Outside the currentregion

Or you could try something like

Please Login or Register  to view this content.

VBA Noob

Hi,

Have you tried the .Resize instruction?

Untested but something like:

Please Login or Register  to view this content.

HTH