Loop Through Open Xcel Workbooks

**pablowilks** · 08-14-2013, 07:28 AM

How would I loop through open excel workbooks and if the cell A1 contains the word 'August, color A1 cell red. if A1 contains the word 'September' color it in blue.
Must loop though workbooks.

**Mordred** · 08-14-2013, 08:27 AM

Hi pablowilks, the following should do the trick

Please Login or Register  to view this content.

**pablowilks** · 08-14-2013, 02:08 PM

thanks mordred

**pablowilks** · 08-14-2013, 02:09 PM

btw what does the Application.ScreenUpdating = False do?
thanks

**Mordred** · 08-14-2013, 02:38 PM

Setting the Applicatioin.ScreenUpdating to False at the beginning prevents the screen from "flickering" while changes are being made to the worksheet.

**Mordred** · 08-14-2013, 03:19 PM

Hi pablowilks,

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Loop Through Open Xcel Workbooks

LinkBack

Thread Tools

Rate This Thread

Display

Loop Through Open Xcel Workbooks

Re: Loop Through Open Xcel Workbooks

Re: Loop Through Open Xcel Workbooks

Re: Loop Through Open Xcel Workbooks

Re: Loop Through Open Xcel Workbooks

Re: Loop Through Open Xcel Workbooks

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Loop to open all workbooks in folder and append data to single sheet

[SOLVED] Open Multiple Workbooks, Record names, Copy paste to Active Workbook, Close the Workbooks

Open workbooks with variables in filename using loop

Loop through, open, and modify all workbooks in file

[SOLVED] Loop Through All Open Workbooks

Bookmarks

Bookmarks

Posting Permissions