LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #13   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,600
Default Custom Function displays as #NAME

I will have to adjust my approach.

A worksheet change event perhaps, or a macro attached to a button.

Regards,
Peter T

"Paul Schrum" wrote in message
...
Peter,

What you describe is indeed what I was attempting to do. I will have
to adjust my approach.

Thank you for your help, and thanks for your patience with me.

- Paul

On Jul 25, 8:45 am, "Peter T" <peter_t@discussions wrote:
I'm still not following but I notice this in your function

Workbooks.Open Filename:=profilesFile

If that's in a UDF my previous response applies, a UDF can only return a
value and can't open a file.

Regards,
Peter T



 
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
Function displays but not the result - cause????? Mark[_7_] Excel Worksheet Functions 3 August 8th 08 03:32 PM
cell displays function not value of function Gina Excel Worksheet Functions 2 November 10th 06 05:26 PM
Custom Filter that Displays All But in Ascending or Decending Orde Kim Excel Discussion (Misc queries) 3 September 14th 05 07:46 PM
Formula window displays correct answer while cell displays incorre MMV Excel Worksheet Functions 3 November 10th 04 09:28 PM
IF function displays wrong amount JAnderson Excel Worksheet Functions 4 November 6th 04 06:41 PM


All times are GMT +1. The time now is 02:02 AM.

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

About Us

"It's about Microsoft Excel"