• Hot Topics

Excel Entering complex formula using VBA

Hi All I've been on this for hours and there must be an easier way to do this but I'd like to persevere with the formula route if possible I'm attempting to enter a formula via vba to add a hyper link, I've been going around in circles for what seems like a lifetime (probably about 2 hours) and cant seem to get it right. A couple of question is it possible to do this??

This question generated 13 answers. To proceed to the answers, click here.

This thread is current as of September 25, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel