Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Replacing values on multiple sheets using a macro

This little bit of code should help you, but you'll have a little bit
of customizing to do before it'll probably work on your computer.
Aside from placing the code into a macro, the only thing you will have
to do is replace the sheet names ("Sheet1", "Sheet 2", etc...) with the
actual name of your sheets. It works best if you double click on the
sheet name, then copy and paste it into this, because sometimes there
is a space that's not visible in the sheet name that will prevent the
code from running. You can put as many sheet names as you like as long
as they are in your workbook, just make sure to put quotes around them
and separate them with commas. Good luck.

Sub SearchReplaceWorkbook()
Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Select
Sheets("Sheet1").Activate
Cells.REplace What:="\=", Replacement:="=", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, _
SearchFormat:=False, ReplaceFormat:=False
End Sub

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Replacing cell reference on multiple sheets in one go.... neilcarden Excel Worksheet Functions 3 August 6th 08 11:20 AM
Help needed replacing multiple cells from a list of values. Emoshag Excel Discussion (Misc queries) 6 July 6th 06 09:15 PM
Lookup multiple values on multiple sheets RealGomer Excel Programming 1 June 7th 05 05:41 PM
Filtering and replacing values through a macro vic Excel Worksheet Functions 1 January 27th 05 09:53 PM
Replacing (identical) values in multiple workbooks simultaneously? BR4M Excel Programming 8 November 25th 04 04:35 PM


All times are GMT +1. The time now is 07:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"