-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
hyperlink; format
-
Imported Hyperlinks lose link
I am VBA noob extraordinaire. I am merging data from multiple WBs. The Source WBs and destination WB are .xls. In all the source WBs, the D column contains hyperlinks that work in the source but after copy in the destination the Address is missing from the Hyperlink properties. Here is...- Sprock
- Thread
- Replies: 3
- Forum: Excel Questions
-
B
Find Hperlinks in column and copy entire row to new sheet
I have a group of worksheets that I want to cycle through and look in column A for a hyperlink. If the cell has a hyper link in it I want to copy the entire row to the work sheet pTable. I have pieced the code below together as a first step to copy the just the link but it does not work with the...- Bonacci8
- Thread
- Replies: 2
- Forum: Excel Questions
-
B
Converting Hyperlinks to URL
Q? I have a several hundred entity names that each function as a hyperlink. Each name is associated with a distinct web URL. While this is cool, I want to format the cells to show only the web URL. How do I convert these hyperlinks to the URL address? Is their a paste special function or command...- Bobdog
- Thread
- Replies: 3
- Forum: Excel Questions
-
B
Hyperlink alignment
If I have a hyperlink that is set up to reference a cell in the same sheet, is there a way to make the referenced cell appear as the top left cell on the screen?- bmars
- Thread
- Replies: 2
- Forum: Excel Questions
-
C
Hyperlink formatting
Simple question - When you create a hyperlink in excel, it automatically makes the text blue with underlining - is there anyway to change this? I've looked everywhere but can't seem to find an answer!- Clare1805
- Thread
- Replies: 2
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
loop through merged cells in a Column to get their addresses
- Replies: 46
I have one column. say column A, which has multiple merged cells of different ranges. for example first cell is merged from A2 to A15 whereas... -
Split a Column into 2, use a character limit that does not cut words in half.
- Replies: 31
Title says it all. I have huge columns of data that can only be 30 characters long. I want to use a formula to split the column into two. The... -
change colour of picture based on cell value
- Replies: 46
hello again guys I have found this video of Bills that explains how I could dynamically change the .width & .Height of a shape in excel, but I am... -
Preventing duplicates
- Replies: 24
Hi everyone, I am using a userform to add data to my worksheet, my userform uses a combobox to to show the list that exsists but also allows for... -
EXCEL SHEET auto enter Dates
- Replies: 23
Hi All , I am came to this forum after a long time , this is the great platform and with awesome people , where stranger of no where will help... -
Code giving run-time error when called, but not when placed on worksheet.
- Replies: 23
The code listed below runs on the worksheet, but gives a [B]Run-time error '424': Object required[/B] when called. I called the code, because when...