Posted to microsoft.public.excel.programming
|
|
Replace text in a cell with text in another cell
You can create a hyplerlink like this using the Worksheet hyperlink function
(in help). I would look at that first and if it doesn't do what you want,
then post back.
=Hyperlink( arguments)
--
Regards,
Tom Ogilvy
"bristol" wrote in message
...
I would like to replace certain text in a cell with text in the adjacent
cell. For example, I have someone's first name in one cell and I have
a email address layout like in the cell next
to it. I would like to write a macro to replace "firstname" with the
cell next to it with the person's first name. Similarly, then, I have
someone's last name in another cell and I would like to write a macro
to replace "lastname" with the cell with the person's last name.
Any macro writers who can help?
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
|