Use an input variable inside a formula

Hi all,

I am trying to create a code that would input a formula, that would split the text from a referenced cell, based on a variable ('Split'). The formula would be apply within the active cell and would prompt the user to select which cell they want to use as a reference ('sCell').

I have come up with the following, however it the sCell variant doesn't seem to work as it inputs the text within the formula...

Appreciate if anyone could assist.

Please Login or Register  to view this content.

Thanks Guru but where about in the code should i place this?

For info, if I remove "Type:=8" then it brings up the cell i have selected, however puts it in between a ' around the reference. As an example if i select cell A1 when asked, the formula will return 'A1', making the formula an error.

Hi TMS, it doesn't work...

Great, that worked. Thanks for your help TMS.