![]() To really force it to run, manually enter another formula in a new cell, for example =STRJOIN(A1:B1). You can verify that it is running by adding a line like MsgBox "STRJOIN() running" at the beginning of the function. Now, what is the problem when STRJOIN is used in a spreadsheet formula? Well, I think the macro just needs to be rerun somehow. It should display "a / b / c" in a message box. Instead, use a subroutine to test it: Sub Test_STRJOINĬall this subroutine either from the macro editor or Tools > Macro > Run Macro. Result = result & before & range(row, col) & afterįirst of all, STRJOIN is a function and was not intended to be run directly. Optional before As String, Optional after As String)įor row = LBound(range, 1) To UBound(range, 1)įor col = LBound(range, 2) To UBound(range, 2) Here's Markus' and Adam's macro: Function STRJOIN(range, Optional delimiter As String, _ I'm particularly concerned about the function suddenly bombing out as I have a ginormous spreadsheet with STRJOIN occurring extensively throughout, and concatenate is not a sufficient substitute. What happened / why is the macro now not functioning? Other macros are working fine, and I also created a new user profile thinking this might help, to no avail. The same errors occurred in OpenOffice as well. If I run the macro from Tools > Macro > Run Macro, I get:Ī Scripting Framework error occurred while running the Basic script.When I run the macro (written by Adam Spiers, based on the work of Markus O'Reilly), I'm now getting the following errors:īASIC runtime error. OSX updates have not occurred since I've returned. ![]() My computer was shut down and left behind, so I'm positive nothing or no one changed anything. I've research this site extensively and can't find the answer to my problem: I've been very successful using the STRJOIN macro in LibreOffice (v4.2.4.2), but after returning to work after a multi-week vacation, suddenly it's not working. I have gotten so much help and value from so many people on this site, so I want to first say thank you to everyone on this forum for their incredible knowledge and generous spirit. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |