Jump to content
Sign in to follow this  
ImageEngine

Newbie...What is wrong with this excel string?

Recommended Posts

ImageEngine

Hi All

Just starting to Au3 and cant get over the bug in this line

$oExcel.activesheet.Range("B2:G2", $oExcel.activesheet.Selection.End(xlDown)).Select

Of course 'xldown' needs to come from somewhere but I cant find a simple explanation; please forgive my newbyness!

As illustrated, I simply want to select from the first part down to the end of the data.

Thanks in advance for any help

Regs

Mark

PS Of course I have established the object etc so everything works when I use;

$oExcel.activesheet.Range("B2:G2").select

Its just that I want to understand how the selection end works from auit.

Edited by ImageEngine

Share this post


Link to post
Share on other sites
GMK

Here is one way:

$oExcel.ActiveSheet.Range("B2:G" & $oExcel.ActiveSheet.UsedRange.Rows.Count).Select

Share this post


Link to post
Share on other sites
GMK

To do it your way, you may want:

Const $xlDown = -4121
$oExcel.ActiveSheet.Range("B2:G2", $oExcel.ActiveSheet.Selection.End($xlDown)).Select ;(Untested)

Share this post


Link to post
Share on other sites
Ktj

Look into help file for examples on gettings range and height on fixed sized boxes

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.