Forum Discussion
Solved
Obtain data from a cell with lots of paragraphs
Cool, So I have multiple questions I need help with regarding formulas and macros. ok, So I have a cell that contains paragraphs of text. Imagine I'm a teacher, and each student gave multiple par...
If you want the function to be available in all workbooks, store it in a module in an add-in or in your personal macro workbook PERSONAL.XLSB.
Is the attached version better?
The names of the modules aren't really important, you can use anything you like, as long as the names are not the same as those of macros or custom functions.
Oooh, so that's why I got the errors and it broke. okok.
I now use an underscore in module names now.
instead of FormatData for both module & macro names. I've changed to,
module-name: Format_Data
macro name: FormatData
shortcut: Cntrl + Shift + F
It's all fixed now. Thank you so much!
I now use an underscore in module names now.
instead of FormatData for both module & macro names. I've changed to,
module-name: Format_Data
macro name: FormatData
shortcut: Cntrl + Shift + F
It's all fixed now. Thank you so much!