Last used row

[tofimoon4]

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.

[tofimoon4]

Dear sir, with my apology i mean (my worksheet ,column D ).

[dilipandey]

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

Please Login or Register  to view this content.

Regards,
DILIPandey

< click on below 'Star' if this helps >

[dilipandey]

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 :-

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

Regards,
DILIPandey

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

[tofimoon4]

Dear sirs,many thanks for help.

[dilipandey]

You are welcome tofimoon4.

Cheers


Regards,
DILIPandey

< click on below 'Star' if this helps >