Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
converting constant/text to formula and evaluate it
Tom, thank you for that script, it works perfectly! Another question.... is it possible to make the result look like link, instead of just text? After I run the function, the cel contents are still black, not the 'expected' blue. It's still a lin but could be made more intuitive by changing its color. Any way to d that? Thanks again! pau -- tsuoyin ----------------------------------------------------------------------- tsuoying's Profile: http://www.excelforum.com/member.php...fo&userid=2011 View this thread: http://www.excelforum.com/showthread.php?threadid=34681 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
converting constant/text to formula and evaluate it
Sub ReevaluateColumnB()
Columns(2).Replace _ What:="=", _ Replacement:="=", _ LookAt:=xlPart, _ SearchOrder:=xlByRows, _ MatchCase:=False Columns(2).specialCells(xlFormulas).Font.ColorInde x = 5 End Sub -- Regards, Tom Ogilvy "tsuoying" wrote in message ... Tom, thank you for that script, it works perfectly! Another question.... is it possible to make the result look like a link, instead of just text? After I run the function, the cell contents are still black, not the 'expected' blue. It's still a link but could be made more intuitive by changing its color. Any way to do that? Thanks again! paul -- tsuoying ------------------------------------------------------------------------ tsuoying's Profile: http://www.excelforum.com/member.php...o&userid=20110 View this thread: http://www.excelforum.com/showthread...hreadid=346810 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting calculation expressed as text into a formula | Excel Discussion (Misc queries) | |||
converting results from formula to text in a new column | New Users to Excel | |||
Converting text string back into a formula | Excel Discussion (Misc queries) | |||
VBA Function to evaluate hlookup text string as formula | Excel Programming | |||
How to evaluate a text expression as formula ? | Excel Programming |