<div>
Thanks helped me out heaps !!
</div>


<div>
<div class="content wysiwyg-content">
Hi, <br />
<br />
We have multiple spreadsheets containing data. Each Spreadsheet is configured in the same format &nbsp;i.e columns are the same. Some of the cells contain IF statements. <br />
Upon analysis, we have found that some of these IF statements require correction. Is there anyway I can edit these if statements across multiple spreadsheets with out having to open each work book and edit it? <br />
<br />
Any pointers would be appreciated. <br />
Thanks <br />
<br />
Matt 
</div>
</div>


Hi, 

We have multiple spreadsheets containing data. Each Spreadsheet is configured in the same format  i.e columns are the same. Some of the cells contain IF statements. 
Upon analysis, we have found that some of these IF statements require correction. Is there anyway I can edit these if statements across multiple spreadsheets with out having to open each work book and edit it? 

Any pointers would be appreciated. 
Thanks 

Matt 

Script or Macro to change IF statements on multiple Excel Spreadsheets

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.