Find cell

[Vsn]

Hello all,

Can someone tell me if it possible to make a VBS function which returns the
cell location.

Imagine somthing like this:

=CellLoc() which should than result in A1 (if it was launched from A1 off
course).

Thx a lot.

Ludovic

 

[Charlie]

Do you mean the cell address?

= ActiveCell.Address(False, False)

 

[macropod]

Hi Ludovic,

Do you mean something like the =CELL("address") worksheet function?

And, just to confirm, VBS - not VBA?

Cheers

 

[Vsn]

Yes eventualy I would like to create a counter.

The function should check the value in the cell above and than ad n, if no
value check one cell above and ad n to that value. And so on until it
reached cell 1.

A and S are to close together i think. Indeed it should had been VBA.

Thx,
Ludovic

 

[Vsn]

Yes it looks like it

I do not get thepoint with your code line.....

Thx,

 

[Ardus Petus]

Enter the following formula in any cell of your worksheet:

=ADDRESS(ROW(),COLUMN(),4)

HTH

 

[Vsn]

Thx,

This will do my project good.

Vsn

Enter the following formula in any cell of your worksheet:

=ADDRESS(ROW(),COLUMN(),4)

HTH