Prefix "www." to Website Address

		Microsoft Office Forums > Microsoft Excel > Excel
Prefix "www." to Website Address

03-05-2012, 11:59 PM

jolivanes

Windows XP Prefix "www." to Website Address

Office 2007

Advanced Beginner

Join Date: Sep 2011

Posts: 91

If the Websites are in Column C, starting at C1, try

Code:

Sub TryThis()
    With Range("C1:C" & Cells(Rows.Count, "C").End(xlUp).Row)
        .Value = Evaluate("""www.""&" & .Address)
    End With
End Sub

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to choose a "List" for certain "Heading" from "Modify" tool?	Jamal NUMAN	Word	2	07-03-2011 03:11 AM
Creating Rules to block Senders by "Nickname" rather than email address	RavnResn	Outlook	1	05-24-2011 01:35 AM
Time limit on the use of "add e-mail address" add-in by Sperry	M777	Outlook	0	04-21-2011 06:39 AM
Find & Replace words with "/" prefix & suffix	tollanarama	Word	4	01-25-2011 02:19 AM
Change "From" Address in Gmail Account for Outlook	BigARC	Outlook	3	03-22-2010 08:00 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:23 AM.