Thread: Last used row

Dear sir,with best regards,i need your help by a code that will take me to the last used row from my worksheet , row D which contains the no. of invoice.
Many thanks in advance.

Hi tofimoon4,

If you have the data filled in column D and you want to know the last used row which has the data, use below code

i = Range("d65536").End(xlUp).Row

Regards,
DILIPandey

< click on below 'Star' if this helps >

Sub dfd()
Hi tofimoon4,

To get to the last cell in column D which was used previously but now is blank, you can use below code :-

Range("d1").SpecialCells(xlCellTypeLastCell).Select

Complete macro code for both the cases, including the one which I had mentioned in my previous email, is given below:-

sub lastrow()

Range("d65536").End(xlUp).Select
Range("d1").SpecialCells(xlCellTypeLastCell).Select

End Sub

Regards,
DILIPandey

< click on the below 'Star' if this helps >

You are welcome tofimoon4.

Cheers


Regards,
DILIPandey

< click on below 'Star' if this helps >