View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
smr78[_2_] smr78[_2_] is offline
external usenet poster
 
Posts: 1
Default VBA formulas in javascript

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/