G
Guest
I have Excel 97 and could do with the add-in?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rog
Nash, you don't need an add in to use this function.
Rgds
Rog
Rgds
Rog
G
Guest
I'm getting a "Sub or Function not defined" message, implying I may not have
the relevant add-in switched on? If so, which one?
the relevant add-in switched on? If so, which one?
B
Bob Phillips
You have it. What do you want to do?
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
D
Don Guillett
If you want to run a formula function in a macro you must use
=if(application.isna( etc
=if(application.isna( etc
G
Guest
Many thanks - All working fine!
Don Guillett said:If you want to run a formula function in a macro you must use
=if(application.isna( etc
S
sulprobil
You can compare with CVErr(xlErrNA)...
HTH,
sulprobil
HTH,
sulprobil
D
Don Guillett
glad to help