Prev: Refresh Listbox
Next: a macro to copy only 2 lines w/i a cell separated by 4 line breaks
From: sali on 14 Apr 2010 17:45
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: Gord Dibben on 14 Apr 2010 19:30
ActiveCell maybe?

Hard to tell from your description.


Gord Dibben MS Excel MVP


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: Tim Williams on 14 Apr 2010 20:41
In a UDF ?

Try

Application.Caller

Tim


On Apr 14, 2:45 pm, "sali" <s...(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 02:57
"Gord Dibben" <gorddibbATshawDOTca> je napisao u poruci interesnoj
grupi:tujcs5dc20qr1l4mvsdtr0g2qll8ktkr96(a)4ax.com...
> ActiveCell maybe?

> 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


'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

----
function mycelladdress() as string
mycelladdress=activecell.address
end function
----


From: sali on 15 Apr 2010 07:28

"sali" <sali(a)euroherc.hr> je napisao u poruci interesnoj
grupi:%23Hi2ShG3KHA.3844(a)TK2MSFTNGP05.phx.gbl...
> "Gord Dibben" <gorddibbATshawDOTca> je napisao u poruci interesnoj
> grupi:tujcs5dc20qr1l4mvsdtr0g2qll8ktkr96(a)4ax.com...
>> ActiveCell maybe?
>
>> 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
>

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


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