Courtesy of John Peltier in an earlier post........

This tells me the address of the highest nonblank cell in column C:

Range("$C$65536").End(xlup).Address

This tells you the row:

Range("$C$65536").End(xlup).Row


"Pubert" wrote in message
...
Is there a VBA Function that will give me the last used
column and row? Or what suggestions does anybody have?




----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---