Search results for query: *

Hi Skip, Thanks for chiming in. For now I am using the function at this link exactly: https://stackoverflow.com/questions/48075370/how-to-insert-multiple-hyperlinks-in-a-single-cell I don't know where to start modifying without breaking it. For the line...

I'm trying to find all hyperlink strings surrounded by parentheses "(" & ")" in my active sheet and perform two functions. Function 1 is to delete the parentheses when a hyperlink string is within them (https://...). It must avoid parentheses that do not contain hyperlinks as they may contain...

Thanks Andrzejek, but that isn't helpful. Would appreciate anyone else's input to this question. It seems to be a common issue for excel users.

Hi there! New to VBA and I'm trying to figure this out. This is an issue I need to automate. Sometimes I have too much text in a cell, and it doesn't fit inside the max Cell Height of 409.5. I'd like to run a script that identifies when a cell's height is 409.5, inserts a row below, merges...

Amazing! It works beautifully! Thank you both so much! This will save me so much time and tediousness.

Hi macropod, I tried your edited macro again, but got the same result. https://www.screencast.com/t/uhPzt6tHC It seems to not delete the ">" at the end of the text string. So while the text hyperlinks, the link is broken :/ I don't know enough to be able to reverse engineer your macro and see...

Hi Andrzejek, Thanks for jumping in this thread as well! I added your suggested code to the top of the Macro. It appears to have executed further, but now has an error elsewhere. Screenshot: https://www.screencast.com/t/DnrpuFsiDuqQ When I press "End" the "<" character is deleted but the ">"...

Hi macropod, Thanks so much for jumping here and helping! I tried to save and run the macro you've suggested, but am getting a Compile error. Screenshot: https://www.screencast.com/t/smbeHSqy I tried following the "PC macro installation & usage instructions" in your signature. I'm not sure...

Hi all! Brand new here and have been reading about VBA and macros in Microsoft Word. I'm trying to automate finding and replacing site URLs with hyperlinked text. Problem: When I import cells from Excel that contain URLs, the URLs import as plain text with angle brackets, for example...