Using Macro to create a split - =R[-1]C for some reason. Please help :)

[robpim]

Hi,

I'm very new to using Macros and I've found this macro online which has worked before but has suddenly stopped working and producing an =R[-1]C error.

Explanation: In the attached excel file there is a "Raw Data" tab. I'm trying to split array (apparently) down columns A, B with column C as the split which is separated by pipes.

The macro attached in the zip file has always handled this perfectly but recently I've been getting =R[-1]C for some unknown reason. R1C1 is un-ticked in "Options --> Formulas

I'd really appreciate you help!

Many thanks,
Rob

[LeoTaxi]

Result in sheet Result

Please Login or Register  to view this content.

Kind regards
Leo

[robpim]

Hi Leo,

Thanks!