Find last filled cell in a column
VJ,
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Sub TEST() Dim RNG As Range Set RNG = Range("A:A").Find(What:="*", SearchDirection:=xlPrevious) If RNG Is Nothing Then GoTo e: 'do something MsgBox RNG.Address e: End Sub - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- Regards, Soo Cheon Jheong _ _ ^ ^ ~ |
All times are GMT +1. The time now is 08:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com