Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 69
Default Source of call to UDF

Hi.

How to find out which cell called udf function?
I did it once, but I don't remember hwo.

Thanks
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 69
Default Source of call to UDF

witek wrote:
Hi.

How to find out which cell called udf function?
I did it once, but I don't remember hwo.

Thanks


Ok. I found it.
Application.Caller.Address
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,440
Default Source of call to UDF

Application.Caller.Address

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"witek" wrote in message ...
| Hi.
|
| How to find out which cell called udf function?
| I did it once, but I don't remember hwo.
|
| Thanks


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How change link source in long formula when source moved Irina Excel Programming 4 June 28th 06 07:27 AM
Call Center Management: How to calculate 'cost per call' Denniso6 Excel Discussion (Misc queries) 2 June 25th 06 05:01 PM
copying and pasting from source sheet to destination sheet without naming source sht? Simon Lloyd[_753_] Excel Programming 5 June 2nd 06 06:11 PM
How can i set the source-data-range of pivottable2 to the source . Piet Excel Discussion (Misc queries) 0 March 5th 05 09:31 PM
How can I change the source of my extern source database in an ex. No Name Excel Programming 3 September 17th 04 10:27 PM


All times are GMT +1. The time now is 06:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"