Results 1 to 12 of 12

Replace Fill Down, Complicated Equation

Threaded View

  1. #7
    Registered User
    Join Date
    09-14-2011
    Location
    London
    MS-Off Ver
    Mac Office 2011
    Posts
    62

    Re: Simple Macro Req. to replace Fill Down COMPLICATED EQUATION

    I altered it to cover the exact sheets named, and I get a compile error.

    I changed the line
    For Each Sh In Worksheets(Array("Sheet2", "Sheet4", "Sheet9"))
    to
    For Each Sh In Worksheets(Array("BHSDB", "BurtonDB", "DaisyAndEveDB", "DivaDB", "DorothyPerkinsDB", "FreedomDB", "GinaTricotDB", "MatalanDB", "TopMan", "WallisDB"))
    Last edited by Paul; 06-14-2012 at 04:57 AM. Reason: Changed QUOTE tags to CODE tags.

Thread Information

Users Browsing this Thread

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

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