my use case is to put Hyperlink (to make the urls look good) in each cell for the column “FilePath”. But this column “FilePath” is dynamic (ie, it can be in col 2 or 20 or 30)
So, I got hold of the cell addres of the column header “FilePath” and now need to use a write Range activity inside a ForEachRow activity while iterating through the datatable rows.
What should I give in the Range for the “Write Range” activity? I cannot use “B” + rowIndex since I know the column position (eg, as 2 as instead of B).
Here’s my incomplete Write Range activity inside the ForEachRow loop. LOL
Range = ???
Value = “=HYPERLINK(”""+strPathVar+""","“Please Click”")"
Need to know how to put the Range ???
Any help is much appreciated.Thank you in advance.