kbay808

<div>
That works, but I'm want to add the hyperlink to the same cell as the existing phone number. &nbsp;The phone numbers is listed in column B and I'm trying to get the link to be in the same cell.
</div>


That works, but I'm want to add the hyperlink to the same cell as the existing phone number.  The phone numbers is listed in column B and I'm trying to get the link to be in the same cell.

<div>
@Norie <br />
How do I adapt your code if the target range is in column E and the location of the for the hyperlink needs to be in column M? &nbsp;I can use the copy and paste function to overwrite the original data and then delete the values in column E as a workaround for the issue stated in my previous post.
</div>


@Norie
How do I adapt your code if the target range is in column E and the location of the for the hyperlink needs to be in column M?  I can use the copy and paste function to overwrite the original data and then delete the values in column E as a workaround for the issue stated in my previous post.

<div>
<div class="content wysiwyg-content">
I have an excel spreadsheet with a dynamic phone list. &nbsp;I want to user to be able to click on the phone number to make a call via the Skype for Business app. &nbsp;I’m able to accomplish this by using the below formula but I want to use VBA to add the hyperlink to any cells in range (“B:B”) if not blank. &nbsp;<br />
<br />
=HYPERLINK(CONCATENATE(&quot;Te<wbr />l:1&quot;,A1))
</div>
</div>


I have an excel spreadsheet with a dynamic phone list.  I want to user to be able to click on the phone number to make a call via the Skype for Business app.  I’m able to accomplish this by using the below formula but I want to use VBA to add the hyperlink to any cells in range (“B:B”) if not blank.  

=HYPERLINK(CONCATENATE("Tel:1",A1))

VBA – How to add a hyperlink to cells in a range?

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

Skype is for doing things together, whenever you’re apart. Skype’s text, voice and video make it simple to share experiences with the people that matter to you, wherever they are.

With Skype, you can share a story, celebrate a birthday, learn a language, hold a meeting, work with colleagues – just about anything you need to do together every day. You can use Skype on whatever works best for you - on your phone or computer or a TV with Skype on it. It is free to start using Skype - to speak, see and instant message other people on Skype for example.