Prev: Refresh Listbox
Next: a macro to copy only 2 lines w/i a cell separated by 4 line breaks
From: Chip Pearson on 15 Apr 2010 07:41
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



On Wed, 14 Apr 2010 23:45:40 +0200, "sali" <sali(a)euroherc.hr> 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!
>
From: sali on 15 Apr 2010 07:59
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

"Chip Pearson" <chip(a)cpearson.com> je napisao u poruci interesnoj
grupi:couds5d9ahddigafcto8rhv8riovl59302(a)4ax.com...
> Application.Caller will reference the cell from which the function was
> called. E.g.,
>
> Function Test() As String
> Test = Application.Caller.Address()
> End Function

>
> On Wed, 14 Apr 2010 23:45:40 +0200, "sali" <sali(a)euroherc.hr> 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!
>>


First  |  Prev  | 
Pages: 1 2
Prev: Refresh Listbox
Next: a macro to copy only 2 lines w/i a cell separated by 4 line breaks