Existing functions

[ZMAN2]

How do you reference existing functions in excel? For example, if I try to create a function and use the existing function find() I get "Sub or Function not defined . Isn't this possible? I can use others like date(), now(), et.,.....

Thanks is advance.

 

[RuralGuy]

Date() and Now() are also Access functions. You will need to set a reference to Excel to have any of it available. <ALT>F11> Tools>References

 

[ZMAN2]

Thanks for the reply. I thought it was kinda wierd that I would have to reference an excel function if I was in excel, but I checked and Microsoft Excel 9.0 Object Library was referenced. It doesn't work or my syntax is bad. Let's say I wanted to use the find function or substitute function in some code:

x=A 'Find Text
y=BBACC 'Within Text
z=Find(x,y)

z should equal 3, right?

or

w = ABC 'Text
x = A 'Old Value
y = B 'New Value
z = Substitute(w, x, y)

z should be BBC

Any help would be appreciated.

 

[RuralGuy]

I'm sorry but I have no knowledge of Excel functions. Maybe an Excel guru will drop by and offer some suggestions.