One way:

myrng.entirerow.select
becomes

with activesheet
intersect(myrng.entirerow,.range("a:J")).select
end with

Change A:J to whatever columns you want.

Tomfizz wrote:

Dave - Thanks a lot !!!!
That's about it, except that I don't want to select the entire row, but
only up to another column (say column J).
the idea is to create a print area corresponding to a table, with a
various number of rows ...
Thanks for the help!
Tomfizz

--

Dave Peterson