Simple Excel Macro help wanted

[yoink 321]

Dead simple, but I can't seem to figure it out.

I'm trying to get an Excel macro to simply press Alt+PgDn 3 times in a row for me based on the position of the active cell so I can fill in some data, hit a shortcut and have it jump to the next set where I can fill in more data....

I'm assuming I need to use the SendKeys expression but can't get it working.

Any VBA folks out there who could help with the code?

[DiverMike 5]

I made a command button that works:

Quote

Sub Button1_Click()
ActiveWindow.LargeScroll ToRight:=1
ActiveWindow.LargeScroll ToRight:=1
ActiveWindow.LargeScroll ToRight:=1
End Sub

For the same reason I jump off a perfectly good diving board.

[tan 0]

I'm no VBA expert, but you could use the default Record Macro in Excel to record these keystrokes and then extract the code.

But because Alt+PgDn moves the "one screen", and each screen is a different size, the number of offset cells is different depending on the screen being used.

Perhaps you could use this for a start:

ActiveWindow.LargeScroll ToRight:=3
ActiveCell.Offset(0, 29).Select


Change the "29" to however many cells fits into 3 screen widths for you. Hope it works for you?

[yoink 321]

uughh.

You're both right. I'm an idiot.


Thanks!

[theonlyski 3]

You're not paid by the hour, are you?

"I may be a dirty pirate hooker...but I'm not about to go stand on the corner." iluvtofly
DPH -7, TDS 578, Muff 5153, SCR 14890
I'm an asshole, and I approve this message

[yoink 321]

Sadly not... wish I was for this.

*goes back to mindlessly entering data.