Split funciton no longer working

K

kevin.jonas

Split() is no longer working. Excel is complaining "Compile Error:
Wrong number of arguments or invalid property assignment"

This is in a funciton that worked yesterday. What could I have changed
to make split not work? I did not touch the macro since it's creation
weeks ago.

Kevin
 
S

SirPoonga

Man, it isn't until AFER I make the post someone tells me they modified
my spreadsheet (and added a split function).
 
F

Frank Kabel

Hi
Split requires Excel 2000+

But if this is not the reason check in the VBA Editor: 'Tools - References'
for missing references
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA compile error with Split Text Function 1
range(range("A1"), range("A1").SpecialCells(xlLastCell)) 1
VBA "Left" not working 6
XNPV in VBA 2
XNPV Function 1
Error message: Compile error: Wrong number of arguments or invalid property assignment 1
Date Format 7
Format code no longer works 5

Top