Select filled cells/rows in a spreadsheet
 

Hi,
I have a worksheet with data looking like that:
# Name Telephone
1 Joe 506
2 Jack 239
3 Bob 897
4
5
....
3000

The number of rows is limited to 3,000, but the rows filled could be
anywhere between 1 and 3,000. I am looking at a VBA macro that could
autmatically select the rows filled, column B being the test.

Thanks for your help !!

Tomfizz

Select filled cells/rows in a spreadsheet
 

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

Select filled cells/rows in a spreadsheet
 

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