How To: Programmatically Scroll Excel

[Will.D]

Hey all,

I'm getting more familiar with ActiveX and its use, however I'm stumped on finding a way to do this.  Has anyone ever programmatically scrolled an Excel worksheet?  Maybe I'm looking in the wrong spot...  Would I be able to find how to do this in the Windows API?

Any thoughts/pointers are much appreciated.

[DavidJCrawford]

Hi Will

Whenever I am unsure how to do something with Excel in ActiveX, I record a macro in Excel. I then go look at the code in the VBA editor.

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 15/11/2006 by _
'

'
    Range("A1").Select
    ActiveWindow.ScrollRow = 27
End Sub

As you can see its possible all you need to do now is translate that to G

cheers

David

Edit: Grammar

Message Edited by David Crawford on 11-15-2006 05:19 PM

[Will.D]

Ahh, thanks very much.

That's a useful piece of advice too.  Wish I'd thought of it 🙂

This will get linked in the Excel thread.

Thanks again David.

[Will.D]

And just for reference...

Message Edited by Will.D on 11-16-2006 08:23 AM