Search : in
By :

Find and Replace a Range on Excel

Last answer on Sep 7, 2009 2:06:28 pm BST Naz, on Sep 24, 2008 10:32:19 am BST 
 Report this message to moderators

Hello,
I want to find and replace a range of values on excel?

Can anyone let me know if this is possible?

Thank you

Configuration: Windows XP
Internet Explorer 6.0

Best answers for « Find and Replace a Range on Excel » in :
EXCEL Macro - Find and replace function -Help Show
VBA: Finding Hdc in an Excel worksheet or UserForm Show VBA: Finding Hdc in an Excel worksheet or UserForm Here are two small examples on how to find Hdc in a worksheet: By clicking on Sheet1 the UserForm is displayed. Put the pointer on UF, hold the left mouse button down and drag the...
Find a string in Excel and remove all cells Show
Avoid duplicates in Excel ShowAvoid duplicates in Excel In order to avoid duplication when encoding in a column from an excel sheet: take the conditional format on the first cell under the headings (eg A2) choose the following formula:...
Renaming multiple files in batch ShowRenaming multiple files in batch Native features Using a third-party program Renaming a large number of files can quickly become tedious. Fortunately, there are tools to automate this task in many cases: Native features On Windows...
Excel – Total Range of Values ShowExcel – Total Range of Values Issue Solution Note Issue I'm trying to get a range of values totalled. I have one set of columns, let’s say column A1 to A200, ranging from -30 up to 1000 and another column adjacent (let’s say B1 to...
Download Advanced Find&Replace for Excel ShowDescription This application is designed by Add-in Express LTD. Advanced Find & Replace is an add-on for Microsoft Excel. It allows you to run multiple searches for values, formulas and comments. The search results are displayed in a floating...
Download Multiple File Search and Replace Show
Download LBE Find & Replace for MS Outlook ShowDescription The application is designed by Leigh Business Enterprises Ltd. LBE Find & Replace for MS Outlook is a tool that allows you to search and replace missing text in your contacts, emails, appointments and many more. Simple and easy to use,...
Ask your question Reply

1

tazz.cz, on Sep 24, 2008 6:35:07 pm BST
  • +9

Hey there,

you mean by use of macros?

   
Reply to tazz.cz

2

Naz123, on Sep 25, 2008 7:37:59 am BST
  • +3

Hi

Yes I wanted it down through Macro's

thanks

   
Reply to Naz123

3

Castellano, on Jun 30, 2009 9:14:38 pm BST
  • +1

I have this in my project but i can replace a ranges of cell.
Sub ChgInfo()

Dim WS As Worksheet
Dim Search As String
Dim Replacement As String
Dim Prompt As String
Dim Title As String
Dim MatchCase As Boolean
MsgBox "This option affect all the worksheet. Is created to change ADM. PERSONNEL, PI/PD NAME or PROJECT TITLE only. " & vbCrLf & "For more info see: SOP Matrix Informes de Proyectos", vbExclamation + vbOKOnly, "Read Before"

Prompt = "What is the original value you want to replace?"
Title = "Search Value Input"
Search = InputBox(Prompt, Title)

Prompt = "What is the replacement value?"
Title = "Search Value Input"
Replacement = InputBox(Prompt, Title)

For Each WS In Worksheets
WS.Cells.Replace What:=Search, Replacement:=Replacement, _
LookAt:=xlPart, MatchCase:=False
Next

End Sub

   
Reply to Castellano

6

 Trowa, on Sep 7, 2009 2:06:28 pm BST

Hi Castellano,

Can you modify the macro so I can find and replace a range of cells which I have currently selected.
So if I select the cells A13:B13, find the exact value on all sheets and then replace it by nothing (delete content).

Any help would be greatly appreciated.

Best regards,
Trowa

   
Reply to Trowa

4

Mady, on Aug 12, 2009 2:26:24 pm BST
  • +1

In column A I have a range of values, which has to be replaced by the range of values in Column B..

Can you help me with that..

Thanks.
Mohan.

   
Reply to Mady

5

filip, on Aug 12, 2009 10:40:18 pm BST

Hi,

you can use Excel Interop or OLEDB but both are very slow if you have larger number of data. I advice you to use GemBox spreadsheet component which is very easy to use.
http://www.gemboxsoftware.com/GBSpreadsheet.htm

   
Reply to filip
Ask your question Reply
They need your help