Office Scripts extract Excel hyperlink URLs without macros; results are hardcoded so the file can stay .xlsx, reuse is straightforward.
Yes. Couple of tips: use datatypes on your parameter declarations and your Function declaration, and "Range" is a (very commonly used) object in Excel so picking a different name for your function ...
Not sure if I'm asking this right, but I have an excel form that a user is asking me to attach formulas with IF...THEN statements to.<BR><BR>The form looks like this ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results