Microsoft Office Forums - View Single Post - Last row used

Thread: Last row used

View Single Post

Old

04-05-2019, 07:33 AM

abenitez77 abenitez77 is offline

abenitez77 is offline

abenitez77 uses Windows 10

Windows 10 abenitez77 uses Office 2016

abenitez77 uses Office 2016

Office 2016

Novice

The original poster

Join Date: Apr 2019

Posts: 9

abenitez77 is on a distinguished road

Default

Thanks, I am using this which is what you have but just added "After:=Cells(18000,5)" It is working fine for me:

Code:

RowLast = Columns(5).Find(What:="*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious, After:=Cells(18000, 5)).Row

Reply With Quote