Key Strokes In Excel Macro

[sgreenwood]

Hi,

Can anyone tell me what the syntax would be for entering a series of key strokes into an excel macro. I know it can be done, but I can't remember how to enter it.

In particular I am looking to put an "end up" and "end down" command.

Thanks in advance for any help!

 

[sgreenwood]

I just remembered how to do it...Thanks!

 

[sgreenwood]

Well...actually I didn't figure it out...maybe I'm going about it the wrong way.

What I'm actually trying to accomplish is creating a macro button equivilent to the "auto sum" function...except I want it to do a "=subtotal" instead of an "=sum".


If I record a macro to do it, it automatically uses the number of rows that I was subtotaling when recording the macro instead of just going to the top of the current data section.

I thought by using the keystroke commands for "end up" and "end down" I could solve this, but I don't seem to be having any luck.

Any suggestions?

Thanks

 

[JVFriederick]

Play around with :

SendKeys "{END}{DOWN}", False
and
SendKeys "{RIGHT}{DOWN}{END}{UP}", True