Fill Down

[James_Newton]

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? ieEnd
and Cursor Arrows?

Thanks

 

[Tom Ogilvy]

Assume you have data in column 1

set rng = Range(cells(2,1),cells(2,1).End(xldown))
rng.offset(0,8).Formula = Range("I2").Formula

--
Regards,
Tom Ogilvy

"James_Newton" <[email protected]>
wrote in message
news:[email protected]...