... From: patbilldavis with the Si570. ... A quick copy from a couple of Dick s posts. It took me a while to realise you had to activate the add-ins. 73 Alan
Message 1 of 2
, Aug 30, 2008
----- Original Message -----
with the Si570.
> I can't get the Xtall-Calc2-VBA program to run. I get a "Type
> mismatch" error in line >>> fxtal = Range("J13")
> Excel line 13 shows >>> #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
> I would like to calculate some different center frequencies and have
> another PIC burned.
A quick copy from a couple of Dick's posts. It took me a while to realise
you had to activate the add-ins.
73 Alan G4ZFQ
The Excel programs all require the Analysis tool pack Add-In. I have
all of the math add-Ins enabled on my systems and the notes on the
second tab [General #11] indicate this. Also need to adj the
security level for Macros. see notes in file section or in the ZIP
The Add-Ins only affect Cells K10 and J13 for the VBA code.
Typically the Analysis ToolPak should do, but I
have all the math add ins installed [Office97, 2000, 2002 and 2003 - do
not have 2007]. Normally the add ins must be first installed and then
activated on the Tools drop down menu - if the box does not have a check
mark the add in is not working. Also in most versions that I have seen
for Office the add ins are normally installed for activation - this
includes the SBE, Student and Pro versions, so I get confused if users
do not have the add ins.
Your message has been successfully submitted and would be delivered to recipients shortly.
Changes have not been saved
Press OK to abandon changes or Cancel to continue editing
Your browser is not supported
Kindly note that Groups does not support 7.0 or earlier versions of Internet Explorer.
We recommend upgrading to the latest Internet Explorer, Google Chrome, or Firefox. If you are using IE 9 or later, make sure you turn off Compatibility View.