First of all let me say the moderator bot or whatever would not allow me to post this question because it contained a link. I had to get creative and replace 5 certain letters with haich tee tee pee ess in the "code" below
I am trying to create a formula that is copyable through a range of cells that will create a hyperlink to a webpage of action items in each cell of column A. The url of each hyperlink is common until the last 5 characters, which is the action item number. The action item number itself is contained in column L, so I wanted to concatenate the partial url and L information together.
After typing in the info, vba brings up the Compile Error: Expected End of Statement while highlighting the "haich tee tee pee ess" text in the formula. I tried the formula on its own in a single cell in the worksheet and it works fine.
Example is below, but url info has been changed due to proprietary info.
The expected result after macro is run: if L1 contains the number 34262, A1 contains a hyperlink to action item 34262 on the website, same for each A cell and its corresponding L cell.
Any insight appreciated
Bookmarks