Thread
:
Excel 2007 macro problem in editing a cell
View Single Post
#
1
Posted to microsoft.public.excel.programming
pjudge
external usenet poster
Posts: 2
Excel 2007 macro problem in editing a cell
I have a column of web addresses, e.g.
www.anywhere1.com
,
www.anywhere2.com
.
etc.
I need to edit these to contain an email address of info@ the original URL,
e.g.
,
, etc.
When I replicate the manual steps that work by using the macro recorder with
relative positions this way:
"F2, Home, delete, delete, delele, delete, info@, enter" it does not work.
Running that macro simply populates the new cell with the email address of
the cell I used for recording, e.g.
, and it is formatted
as text only, not an email link.
I don't know
VB
so I can't edit the macro script and am simply lost as to
why the recording fails to give the same results as the manual steps.
Thanks in advance.
Reply With Quote
pjudge
View Public Profile
Find all posts by pjudge