Formula to determine if the cell is selected:

[pedie]

I have no idea but is there by any chance a formula to know what the active selection cell?

suppose i click on B1 and in A1 = formula??? will show "B1"...I am talking bout formula not click event code etc.

If there is any such formula then pls share...I was kinda increased expectation as the other Peter gave a formula to find the activeworkbook path by just entering a formula..

Thanks for reading..now psl answer:

 

[pedie]

Related Link

 

[Jaafar Tribak]

This is taken from the XLM help file :

The following macro formula puts the reference of the active cell into the cell named Temp:
FORMULA("="&REFTEXT(ACTIVE.CELL()), Temp)

I have tried adding a name that refers to the above EXCEL4 formula but coudn't make it work. I hope someone can and let us know .

 

[JackBean]

Is this what you are trying to do?
With Cell A3 selected:

Excel Workbook
	A	B
1
2		Formula: A3
3
...

Sub Aktivecel()
[B2] = "Formula: " & Replace(ActiveCell.Address, "$", "")
End Sub