Wrong number of arguments or invallid property assignment

[JohnGreen2]

I have copied this sheet Grid to another workbook but I am receiving the error below. It works fine in my orginal workbook but in the new workbook I am receiving below attached error -Rep for anyone that can help me to solve this

Many thanks

[rorya]

I'd suspect you have something (sub/function/module/variable) in your new workbook called Split. It's never a good idea to use the name of VBA functions for your own code.

[JohnGreen2]

I'd suspect you have something (sub/function/module/variable) in your new workbook called Split. It's never a good idea to use the name of VBA functions for your own code.

I just checked......changed to VBA.Split and now it works -thanks for pointing me in correct direction