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.
Bookmarks