Excel COM - Select cell under current active cell Topic is solved

[harpo]

Ok, so. First time poster but I Love AHK, been using it alot the last year and gotten lots of work done.

Anyhow. Ive started using COM to work with Excel, but Im still pretty stupid about it.

I know I can select a cell with for example:
XL.Range("B2").Select

But how do I give the select function the current cell, +1 in row? So say I have B2 selected, I want to select B3. Or if D10 is currently selected, I want to select D11.
I dont understand how to pass the current cell information into the Range().Select function.

I want to do something like XL.Range(CurrentCellRow+1).Select

Thanks.

[kon]

Hi

Here's a link to a recent topic that is almost identical. It moves the selection one to the right, but going one down would be similar. (Use .Offset(1, 0) instead of .Offset(0, 1).)

More related links:

• MS Office COM Basics
• ActiveCell example
• ActiveCell example 2
• More Examples

[Obumbration]

Hi Kon.

Great, got it working now. Thanks.

On an unrelated topic, I need to run the script as administrator. But running the script using COM as administrator causes an error, stupidly enough. You have any idea how to fix this?

[Obumbration]

Nevermind.

Running both the script and excel in admin mode seems to be working fine.