ExcelBanter - thiscell

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - thiscell (https://www.excelbanter.com/excel-programming/441672-thiscell.html)

sali

thiscell

in excel/2000, is there some property like 'thiscell' in excel/2007?

so, when vba function is called to determine from which cell is called

thnx!

Gord Dibben

thiscell

ActiveCell maybe?

Hard to tell from your description.

Gord Dibben MS Excel MVP

On Wed, 14 Apr 2010 23:45:40 +0200, "sali" wrote:

in excel/2000, is there some property like 'thiscell' in excel/2007?

so, when vba function is called to determine from which cell is called

thnx!

Tim Williams[_4_]

thiscell

In a UDF ?

Try

Application.Caller

Tim

On Apr 14, 2:45*pm, "sali" wrote:
in excel/2000, is there some property like 'thiscell' in excel/2007?

so, when vba function is called to determine from which cell is called

thnx!

All times are GMT +1. The time now is 05:29 PM.