Results 1 to 7 of 7

Macro to Change Cell Background Color From White to No Fill

Threaded View

emcdemc Macro to Change Cell... 01-06-2009, 06:14 PM
VBA Noob Maybe Sub... 01-06-2009, 06:26 PM
emcdemc Thank you! That works but it... 01-06-2009, 06:56 PM
emcdemc Thanks, the second one seems... 01-06-2009, 08:23 PM
shg You were close. You can't... 01-06-2009, 08:36 PM
emcdemc Perfect thank you! 01-06-2009, 08:51 PM
shg You’re welcome. Would you... 01-06-2009, 08:55 PM
  1. #4
    Registered User
    Join Date
    01-06-2009
    Location
    NYC
    MS-Off Ver
    Excel 2003
    Posts
    4
    Thanks, the second one seems to work but how do I get it to cycle through each sheet in the workbook? Here is what I have:

    Sub White2Blank()
    Dim Ws As Worksheet
    
    For Each Ws In Worksheets
        Cells.Select
        Application.FindFormat.Clear
        Application.FindFormat.Interior.ColorIndex = 2
        Application.ReplaceFormat.Clear
        Application.ReplaceFormat.Interior.ColorIndex = xlNone
        Selection.Replace What:="", Replacement:="", LookAt:=xlPart, SearchOrder _
            :=xlByRows, MatchCase:=False, SearchFormat:=True, ReplaceFormat:=True
    Next Ws
    End Sub
    Last edited by emcdemc; 01-06-2009 at 08:49 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1