thiscell

[sali]

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]

ActiveCell maybe?

Hard to tell from your description.


Gord Dibben MS Excel MVP

 

[Tim Williams]

In a UDF ?

Try

Application.Caller

Tim

 

[sali]

ActiveCell maybe?

'activecell' was my first thought, and it is evaluated ok when you 'enter' a
formula containing vba macro into cell-by-cell, but if you 'copy' such a
formula into range of cells, then macro is evaluated, but without updating
activecell, so it fails

 

[sali]

just for the info, browsing this group, i've found the answer

it is 'application.caller', as described on
http://www.cpearson.com:80/excel/writingfunctionsinvba.aspx

 

[Chip Pearson]

Application.Caller will reference the cell from which the function was
called. E.g.,

Function Test() As String
Test = Application.Caller.Address()
End Function

There is also an object named ThisCell which does the same thing but
behaves differently with array formulas.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com

 

[sali]

as you can see, 10 minutes ago i've found exactly that info on your web
site, as i've reported in my prev post

thnx again for your helpfull site