-
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
-
problem function date add into datepicker on userform
- Started by abdelfattah
- Replies: 48
hi i have problem add years and months days is ok i have textbox1= days textbox2= months textbox3= years when i... -
Vlookup Help
- Started by tomehta
- Replies: 35
Hello In attached excel screen shots, in Col I (sheet 1), I want Col C value (from sheet 2), similarly in Col P (sheet 1) want Col D value( from... -
Split cells based on specific text which may occur multiple times in cell
- Started by charlie_580
- Replies: 25
Hi I wonder if anyone can help? I need to split multiple cells by code, however the code may occur within the original cell more than once. and... -
AVERAGE RANGE CELLS DD:HH:MM FORMAT
- Started by LawNapier
- Replies: 25
I am trying to average the below in DD:HH:MM format. The cells format is set as "custom > DD:HH:MM". I want to only average the time for the... -
Need to color specific cells on another sheet automatically
- Started by csteps
- Replies: 23
Need the cells listed in yellow to color those cells on another sheet automatically [ATTACH type="full"]14354[/ATTACH] -
Move Files To Dynamic Folders Based On Cell Value
- Started by wells
- Replies: 22
Im not sure this is still possible... I referred few posts but they dont work with current office edition.. I have a folder with say around 100...