Hi Tony,

Try to re-assign the formula in the column B

oSheet.Range("B2").Formula = oSheet.Range("B2").Formula
...

>Below is some data created in a VFP Table and COPY TO SpreadSheet.XLS TYPE XL5
>Once in the worksheet the Hyperlink can be physically activated by double-clicking in a cell on column B and pressing return. Once activated this then can be copied to every cell in that column. This work fine interactively.
>
>I want to reproduce this using automation. Any ideas? How do I programmatically active the Hyperlink?
>
>
>Sample of Data in a Worksheet
>

>Column B             Column O                                           Column P
>=HYPERLINK(O2,P2)    https://www.questback.com/-63659397-rQqLrOoc	OLDGN@PARK158912.47771
>=HYPERLINK(O3,P3)    https://www.questback.com/-63659976-bFmuNuaW	OLDGN@6445.46841
>=HYPERLINK(O4,P4)    https://www.questback.com/-63659975-VKqXgRxS	OLDGN@6445.47558
>=HYPERLINK(O5,P5)    https://www.questback.com/-63658304-KUBECjHy	OLDGN@PARK219167.46555
>