Hi Luke,
Unfortunately recording a macro won't give me the answer. The complete code for what I am doing is this:
Everything is fine and does its job except for the last bit where I try to select a specific cell so the user doesn't have to scroll down to it etc. Even though the cell is selected on screen Excel doesn't seem to think it is the active cell and the user then has to click on that cell again before Excel realises that is where you want to type in data (in my case an Item Code).
I would go down a userform route to allow the user to enter data for the new row but at this stage it's not really a necessity and this odd 'bug' is driving me nuts so I'm trying to figure out what I've done wrong in case I need this again for something.
Bookmarks