Activecell and worksheet excel

Belias

i need to use activecell together with worksheet.
why?In a process I'm using activecell property (example)

xlapp.range('F4').activate;
myint := xlapp.activecell.row;

obviously this is not my case, otherwise i can solve it in another way.
I need to do a find in excel, retrieve excel row and col of the active cell (that i found before) and then use them.
The problem is that now i need to do this on 2 different sheets, so i need to fill the cells using xlworksheet instead of xlapp.
well, activecell doesn't work with xlworksheet, but only with xlapp.
how can I select the active worksheet for the current instance of xlapp?
otherwise, how can I use worksheet together with activecell?
p.s.: I can't use excel buffer because the export is too complicated

thanks in advance

imurphy

Not sure I understand what you are looking for, but....

activecell.row returns the row object, not the row number. For this you need to do this (example from excel - not Nav):

Dim oRow As Range
Set oRow = ActiveCell.Row
Debug.Print oRow.Row

the same applies with activecell.column

If you want the activeworksheet, you can get it from the activecell: activecell.worksheet

There is always only one active cell - not one active cell per worksheet.

Its not clear from your email but it may be that what you want is the currently selected cell on a particular sheet.

If you have doubts about what is available I'd recommend opening the vba editor from excel and using intellisense to see what methods can be called or not. In excel you can type a single line of code and just execute it - much like in a debugger evaluation window.

Ian