Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formulas to values
First of all let me say that I am very now to all of this. I can barel
sort. Ok I have a column of hyperlinks of which I need the addresses so that I can transfer the data into Access. I managed to get thi function to work: Function LinkAddress(cell As Range) 'Lists the Hyperlink Address for a Given Cell If (cell.Range("A1").Hyperlinks.Count < 1) Then On Error Resume Next LinkAddress = cell.Text Else LinkAddress = cell.Range("A1").Hyperlinks(1).Address End If End Function Unfortunately when I make a bunch of cells with this in it, I can' transfer the data anywhere because the formulas get transfered and no the values(the addresses). Can I make a macro that will go down th column, run this function, and then place the value it gets in the nex column to the right? That sounds pretty straight forward I just hav no idea how to do it. Advice please. -Spork Ps. this was just answered in the thread titled "To Tom" but I coul not understand how to take that spefic solution and apply it to m problem. : -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
formulas to values
If you're adding the formula manually, you could just copy that range and
paste|special values. "Spork Rhonewood <" wrote: First of all let me say that I am very now to all of this. I can barely sort. Ok I have a column of hyperlinks of which I need the addresses, so that I can transfer the data into Access. I managed to get this function to work: Function LinkAddress(cell As Range) 'Lists the Hyperlink Address for a Given Cell If (cell.Range("A1").Hyperlinks.Count < 1) Then On Error Resume Next LinkAddress = cell.Text Else LinkAddress = cell.Range("A1").Hyperlinks(1).Address End If End Function Unfortunately when I make a bunch of cells with this in it, I can't transfer the data anywhere because the formulas get transfered and not the values(the addresses). Can I make a macro that will go down the column, run this function, and then place the value it gets in the next column to the right? That sounds pretty straight forward I just have no idea how to do it. Advice please. -Spork Ps. this was just answered in the thread titled "To Tom" but I could not understand how to take that spefic solution and apply it to my problem. : ( --- Message posted from http://www.ExcelForum.com/ -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas to Values | Excel Worksheet Functions | |||
IF formulas with more than two possible values | Excel Discussion (Misc queries) | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
values in IF formulas | Excel Worksheet Functions | |||
Formulas as Values | Excel Discussion (Misc queries) |