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

[ImageEngine 0]

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 September 10, 2007 by ImageEngine

[James 374]

Why dont you use AutoIt3? Many bug fixes have been fixed etc, and the new syntax is great. Check it out, then post in the General Help and Support forum.

[GMK 23]

Here is one way:

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

[RDSchaefer 0]

Google for "Excel VBA constants"

Ralph

[GMK 23]

To do it your way, you may want:

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

[Ktj 0]

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