Oops in code

ActiveCell.CurrentRegion.Select

Or for the usedrange

ActiveSheet.UsedRange.Select



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Debra Ann" wrote in message ...
I have some raw data in a spreadsheet that came from another software. I
want to have a macro select all the cell range that contains information in
it so that I can have the macro format the fonts, cell frames, etc. How do I
have it search and select the columns and rows that contain the data?


--
Debra Ann