Thread: Illegel Error on a Function Call
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Syed Zeeshan Haider[_6_] Syed Zeeshan Haider[_6_] is offline
external usenet poster
  
Posts: 3
Default Illegel Error on a Function Call
"NickHK" wrote in message ...
Syed,
I would assume that it is being treated as the VBA version of the function
call.
Try typing "VBA." and see "Split" apears as an option.

As a matter of fact, Split() function was not available until VBA6 while
Excel 97 Pro uses VBA5. That's why MS has provided these functions for VBA5
users on their site and I copied those functions for the reference.

Thanks,
--
Syed Zeeshan Haider


-----------------------------------------------------
http://szh.20m.com/
http://gomusharrafgo.20m.com/


Reply With QuoteReply With Quote