Fill Down
 

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


--
James_Newton
------------------------------------------------------------------------
James_Newton's Profile: http://www.excelforum.com/member.php...o&userid=18327
View this thread: http://www.excelforum.com/showthread...hreadid=466205

Fill Down
 

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"
wrote in message
news:James_Newton.1v3byl_1126267832.6314@excelforu m-nospam.com...

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


--
James_Newton
------------------------------------------------------------------------
James_Newton's Profile:
http://www.excelforum.com/member.php...o&userid=18327
View this thread: http://www.excelforum.com/showthread...hreadid=466205