Home |
Search |
Today's Posts |
#8
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Just in the interest with compatibility with Excel 2007 which as
many more rows than 65500, you should use Range(Range("A1"), Cells(Rows.Count, "A").End(xlUp)).Select -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "excelent" wrote in message ... Range(("A1"), Range("A65500").End(xlUp)).Select |