Hi,
I found part of the solution with :

excel.ActiveSheet.Cells.find("*", excel.ActiveSheet.Cells(1),null ,null
, 1, 2).Row

I checked that VBA formulas are not case sensitive once in Javascript.

Now I have to find how to select this calculated Range :
Range(Cells(r+ 1, 1), Cells(r+ 1, c)).select

Next post?



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/