Solved

Find/Replace

Posted on 2013-01-31
2
172 Views
Last Modified: 2013-01-31
Hi,

I need some code to count column E, loop to the end of that count and if it finds "John Smith", replace with "Tony boat"

Thanks
0
Comment
Question by:Seamus2626
2 Comments
 
LVL 24

Accepted Solution

by:
Steve earned 500 total points
Comment Utility
One line will do that:

Columns("E:E").Replace What:="John Smith", Replacement:="Tony Boat", LookAt:= _
        xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
        ReplaceFormat:=False

Open in new window

0
 

Author Closing Comment

by:Seamus2626
Comment Utility
Thank you!
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now