thiscell

  • Thread starter Thread starter sali
  • Start date Start date
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!
 
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
 
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
 
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
 
Back
Top