LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default VB won't recognize function in Analysis Tool Pak

I am running Microsoft Office 2000 professional edition. I wrote a VB macro for an excel spreadsheet. I need to use some functions like LCM (least common multiple) and GCD (greatest common divisor). I have an old Function Reference Manual which states that these functions may be accessible only by loading the Analysis Tool Pak. I did that and loaded the Analysis ToolPak, Analysis ToolPak - VBA, and Update Add-in Links. (Tools menu, then Add-Ins). The system asked for the CD rom which I insereted - so it looked like it did add it in. Unfortunately when I try to execute the macro I keep getting the message Run-time error '438'. Object doesn't support this property or method. When I click on the debug option the system points to the exact statement with the LCM function. Am I missing something? Any ideas


 
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
Data Analysis Tool Cesar Excel Worksheet Functions 5 February 24th 09 04:44 AM
Problem with Regression function in 2007, Analysis Tool Pak Lauren273 Excel Discussion (Misc queries) 2 May 25th 08 10:00 PM
analysis tool Alex Excel Discussion (Misc queries) 5 May 10th 06 10:26 PM
How can I add data analysis function in tool? Michiko Excel Worksheet Functions 1 November 8th 05 09:26 AM
After adding Analysis Tool Pack, still no PRICE function, why? mtburdett Excel Worksheet Functions 1 November 5th 05 09:43 AM


All times are GMT +1. The time now is 10:25 PM.

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"