thiscell

S

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!
 
S

sali

Gord Dibben said:
ActiveCell maybe?
Click to expand...


'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
 
C

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
 
S

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
 
Top