hyperlink cells

I am having trouble with 2 issues (don't know if 2nd one was fixed because I haven't been able to get past runtime error '1004': Application-defined or object-defined error Here is my entire code: Sub loanDisbursementNotification() Dim lr As Long, x As Long, y As Long Dim strHeader As String...

Hi, Need to create a bunch of links in excel. Got this far but don't know the syntax for using a variable in a cell address... With Worksheets(1) Dim LCounter As Integer For LCounter = 3 To 33 ActiveSheet.Hyperlinks.Add Anchor:=.Range("az,&LCounter"), _ Address:=""...

Hiya, I have a Hyperlink function that opens Outlook to a specific email address relevant for that supplier. Is it possible to also run a macro, that copies and Pastes the text from cell H7 into the body of the email the hyperlink created? Many Thanks

Hi Everyone! I have a workbook i created as an order management system at work. The user form passes data to the sheet. Each PO # has it's own row. I also save a PDF copy of each PO to a folder on my PC. This is a section of my "submit" button code "txtSSPO" is the text box where the PO # is...

Hello everyone, I'd like to ask a question about the version I generally use, Excel 2010. I prepared multiple tables in different sheets and used hyperlink cells to navigate the user to other sheets and tables. As the sheets and tables are so crowded, When a hyperlink cell is clicked, it is...

Hello there, I have TEXT in A1 and LINK in B1, is it possible to get the link from B1 and hyperlink it to A1? Thanks!

Is there a simple way to merge <tbody> John Doe jdoe@email.com Joe Bloggs jbloggs@email.com Buck Rogers brogers@email.com </tbody> into a single column with the email hyperlink already embedded beneath the name? I don't want to have to Ctrl+K and manually insert for each of the...

Hi All, I am having two columns - First column has Link (Url) and 2nd Column has Friendly Name.Using HYPERLINK formula, I am able to create the Hyperlink in excel but to make it dynamic, I need to use VBA Code. Kindly let me know how I can use the HyperLink formula - "HYPERLINK(I9,H9) " in...

Hello, I have received some great advice on here before and I'm hoping someone can help me again. I'm looking to enter a date in cell G2 on sheet 1 that then looks for a matching date within cell F2 on all the other sheets within the same workbook (each day of the month has it's own sheet) and...

Hi, I'm wanting to add a hyper-link to a cell, but i need the text from that cell to be at the end of the hyper-link. Eg. Column A would contain reference numbers, and each reference number points to it's respective link A1 = a12f345hj6 A2 - asd456gfhj I want to hyperlink: cell A1 to...

Good Morning, I am new to programming and looking to make this code below even more user friendly. Right now the user has to double click on the cell to get the VBA to take the cell information and plug it into the URL based on criteria in the code. Is there a way to have the VBA run through...

Hello, I am having an issue with Excel. I got an array-index formula on one sheet (SearchSheet) that returns values from another sheet (DataSheet) based on date or name searches-inputs. So if I enter 15/5/2015 it will return all the values from my datasheet, whose dates are the same or the...

Hi, This is my first post. I am normally a bit of a lurker. I tried for about 4 hours to work this out yesterday and few hours today on this one. I am using Excel 2010 and Windows 7 64bit. I am using an excel workbook that is updated and changed constantly, Rows are added daily, columns...

i'm curious if this is possible: first, lets say at the bottom of my worksheet i have cells A100-A110 each containing the text of either "V1", "V2"....."V10", now say if i enter into a blank cell the text "V1", is there a way to create a formula where it turns that cell into a hyperlink to...

I maintain a membership roster using Excel 2007. The roster includes a column for each member's email address, and I've formatted this column so the content appears in plain text. However, every time I add or update an email address, that cell's formatting automatically inserts a hyperlink...

In these lines of code I am adding hyperlinks to cells in a row. It shows my steps recorded but since there are some 4,000 cells I need a macro to do it automagically. The target cells are in sequential worksheets but in each case follow the sane pattern (i.e. P2, H3, X3, D4, etc.). Could I...

Hello all, I am a novice at using Excel as i am normally the member of IT staff supporting the user but have now become the user. I am looking to link two Excel documents together with one document having a reference number hyperlinked to a user name on a seperate Excel document. I can...

I've searched for some VBA solutions to this but I haven't found one that suits my needs. I'm using Excel 2007 and I'm a VBA novice. Problem: The macro will be assigned to a command button and will be used by laypersons when they finish filling in data on a worksheet in Workbook 1. The...

Hi, I'm writing a macro that will pull a data from different reports. Normally I would just link the cells but the cells I need change. I have a formula that I can use the value from as a relative reference to tell me what cell the data is in, but I don't know how to add the link in VBA. I'm...

Hi Folks, These seems like it should be simple, but it's hanging me up. I want to hyper link data in one tab (Data) to the data in another tab (values) if certain criteria are met. For example, the Data tab will have names in Column A, date of birth in column b and member number in column c...