find & replace macro

Hello, I'd like to create VBA code to find yesterday's date and replace it with today's date. The date is the format YYYYMMDD and is mixed-in with other text in the cell, e.g. ABC YYYYMMDD XYZ Cells.Replace What:="20130321", Replacement:="20130322", LookAt:=xlPart, _...

I am a records management auditor, I recently switched to using Excel from other programs and I am hoping there is a way to make my life easier, What I want to do is scan a barcode with a barcode scanner and have it find the barcode in my Excel workbook, and then populate a cell a few columns...

I have the following formula in column B of a worksheet: =IF(INDIRECT("Programado!B4")="","",INDIRECT("Programado!B4")) The formula's purpose is only to display what text/value is found in cell B4 on the Programado worksheet of my workbook. Because this is an indirect formula, when I fill it...

Hi All, I have a macro which converts a spreadsheet I use on a regular basis into a csv file for importing into a different software package. Part of the macro code is to find and replace data within the sheet, this generally works very well; however I have identified a fault with it which...

Hi, I’m George, fairly new to Excel/Marco programming. I have (what I hope) is a rudimentary question. I found this thread describing a way to do multiple Find/Replace’s in a large chunk of data: http://www.mrexcel.com/forum/showthread.php?t=486818 I like this solution...

Hi, Is there a shorter way to achieve the same result by shortening the VBA code. Please explain in detail if it can be done, so that I can edit it in future if there are some changes. Here is the Macro: Sub FindReplaceFor_RD() Cells.Replace What:="A1", Replacement:="A01", _ LookAt:=xlWhole...