Sendkeys "{pgdn}" in Excel 2003/2007
 

In Excel 2003 I am using...
Sendkeys "{pgdn}", True
....to actvate a cell one screen down. It is activated but not selected, but
that is fine for my purposes. However in Excel 2007 this does not activate
the cell one screen down, so my macro doesn't work.

I tried ActiveWindow.LargeScroll Down = 1 in both Excel 2003 and 2007 and it
doesn't activate the cell one screen down.

How can I activate a cell one screen down in both 2003 and 2007, accounting
for the fact that the application may be used by different people on
different computers with different screen resolutions?

Sendkeys "{pgdn}" in Excel 2003/2007
 

Hi Steve

Try this

ActiveWindow.LargeScroll Down:=1
Cells(ActiveWindow.ScrollRow, ActiveWindow.ScrollColumn).Select




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Steve" wrote in message ...
In Excel 2003 I am using...
Sendkeys "{pgdn}", True
...to actvate a cell one screen down. It is activated but not selected, but
that is fine for my purposes. However in Excel 2007 this does not activate
the cell one screen down, so my macro doesn't work.

I tried ActiveWindow.LargeScroll Down = 1 in both Excel 2003 and 2007 and it
doesn't activate the cell one screen down.

How can I activate a cell one screen down in both 2003 and 2007, accounting
for the fact that the application may be used by different people on
different computers with different screen resolutions?

Sendkeys "{pgdn}" in Excel 2003/2007
 

That did it - Thanks.

"Ron de Bruin" wrote:

Hi Steve

Try this

ActiveWindow.LargeScroll Down:=1
Cells(ActiveWindow.ScrollRow, ActiveWindow.ScrollColumn).Select




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Steve" wrote in message ...
In Excel 2003 I am using...
Sendkeys "{pgdn}", True
...to actvate a cell one screen down. It is activated but not selected, but
that is fine for my purposes. However in Excel 2007 this does not activate
the cell one screen down, so my macro doesn't work.

I tried ActiveWindow.LargeScroll Down = 1 in both Excel 2003 and 2007 and it
doesn't activate the cell one screen down.

How can I activate a cell one screen down in both 2003 and 2007, accounting
for the fact that the application may be used by different people on
different computers with different screen resolutions?

Sendkeys "{pgdn}" in Excel 2003/2007
 

Steve

You shouldn't need to activate/select for your code to work.

Sendkeys "{pgdn}" in Excel 2003/2007
 

When I start in a particular rowl and do a pgdn, I want to determine which
row I am actually end up in. Ron's suggestion gives me that.

"norie" wrote:

Steve

You shouldn't need to activate/select for your code to work.

Sendkeys "{pgdn}" in Excel 2003/2007
 

If you want to determine which row you are 'in' why not use
ActiveCell.Row.