Hi Steve,

In addition to bhodsetz's response, change:

NumRows = Cells(Rows.Count, "C").End(xlUp)

to:

NumRows = Cells(Rows.Count, "C").End(xlUp).Row


---
Regards,
Norman



"STEVEB" wrote in
message ...

bhofsetz,

Thanks for your help!

When I input the code:

NumRows = Cells(Rows.Count, "C").End(xlUp)
Range("A1:C & NumRows").Select

I get this error:

Run-time error '1004':

Method 'Range' of object '_Global' failed

Am I doing something wrong?

Thanks again


--
STEVEB
------------------------------------------------------------------------
STEVEB's Profile:
http://www.excelforum.com/member.php...fo&userid=1872
View this thread: http://www.excelforum.com/showthread...hreadid=390997