Double click Cell Border by Macro

Dear all is it possible to have a code which allows me exactly the task which I can perform by double clicking cell border as shown in attached gif
By this way I can go to end of last filled cell in range
I wan to have code like this:

sub test()
by double click
go to last filled cell in range
end sub

doubl click.gif

Thanks

Originally Posted by mehmetcik

Press Ctrl and the Down Arrow.

Sir I require vba code

Sir
It's solved

Sub test()
ActiveCell.Application.SendKeys ("^{DOWN}")
End Sub


Thanks a lot

Thanks sir

Originally Posted by mehmetcik

Use the Macro recorder.

Press Ctrl and the Down Arrow.

Returns the following code:

Please Login or Register  to view this content.

Thanks for ur code