hyperlinks.add

Hi, i think this is just a syntax issue but i cant seem to get it right. If anyone can help i would be very grateful. this script works at looping through all of the workbooks in a user defined folder and copying a specified range to a big list in the target worksheet of the workbook where the...

Hi all, I have a worksheet VBA macro to install an index hyperlink into the workbook spreadsheets that is activated upon going to the index worksheet itself. (clicking tab) or clicking the hyperlink to the index sheet in cell A1. There is no problem in the Excel 2010 or 2013 environment. My...

Appreciate help with understanding how a VBA macro that works fine in Excel 2010 and 2013, but that generates an error (Run-time error '1004': Application-defined or object-defined error) when executing in version 2016 explicitly. The macro is embedded with a sheet in a workbook (the "Index"...

Appreciate help with understanding how a VBA macro that works fine in Excel 2010 and 2013, but that generates an error (Run-time error '1004': Application-defined or object-defined error) when executing in version 2016 explicitly. The macro is embedded with a sheet in a workbook (the "Index"...

Invalid Procedure Call or Argument I'm not sure why I'm getting this error I copied the hyperlinks.add syntax from a previous macro I had written that works fine... Any help would be appreciated Sub MCM_CV_RESET() Dim W As Worksheet Dim M As Worksheet Dim Cel As Range Dim RefPtW As...

Hi I have been using the following code to activate hyperlinks for a long time: Sub Test() Dim LastRow As Long, i As Long LastRow = Sheets("Sheet1").Range("B" & Rows.Count).End(xlUp).Row For i = 2 To LastRow With Cells(i, 2) If .Value <> "" Then...

I am learning VBA for excel. I have need to add hyperlinks to a series of some 4000 cells.Each is based on a identical cell pattern in sequential worksheets. So far I have tried the following: Range("B2").Select ActiveSheet.Hyperlinks.Add Anchor:=Selection, address:=""...

I have two lines of code that create hyperlinks from within my macro. However, I'm curious why there is such a huge difference in the output... can anyone help me understand what is going on to make these two different? METHOD 1 USE: ActiveCell.Formula = "=HYPERLINK(""" & fullPath & """,""" &...