Hi

I have created a macro that sorts our bank download into each individual bank account!

On this download i have to put in a custom formual into cell I2 and this has to be copied down to the end of the data, however each day the amount of data changes and the problem i am having is that excel remembers the cursor position not the keys pressed ie End and Down arrow to get to the bottom of the list!

Is there any way I can get excel to remember the keys i press in Vba? ieEnd and Cursor Arrows?

Thanks