I am trying to create a macro for a range of cells in a column which takes me to the first empty cell in that range, however when i am running the macro it goes to the bottom of that column. I have drop down menus in the range of cells for which i am making the macro (may be if this info could help)
My code is as follows
[/CODE]
Sub gemempty(Control As IRibbonControl)
Range("A14:A78").End(xlDown).Offset(1, 0).Select
End Sub
[/CODE]
I have attached a screenshot of where the cursor goes when i run the above macro.
Regards
Nirmall
Bookmarks