+ Reply to Thread
Results 1 to 1 of 1

Delete cells based on pattern

Hybrid View

Nkpg011 Delete cells based on pattern 03-18-2013, 02:23 PM
  1. #1
    Registered User
    Join Date
    02-15-2013
    Location
    Sweden
    MS-Off Ver
    Excel 2010
    Posts
    1

    Delete cells based on pattern

    Hello!

    This is my first post here. I have tried to search the forum for the problem i'm having but i can't seem to find any answer to it.

    I'm trying to make a rooster for schedules which i'm later going to use the solverfunction with. That i don't have any problems with.

    The problem is that for example, cells from B2:AL2 is locked to B1802. Within that range some cells are blank. The blanks represent breaks and lunchbreaks and i've done a total of 64 combinations for each time a new schedule period can start.

    Since i locked every cell like my example above from B2 to B1792 i need to clear same cells for 64 rows at the time. Doing this by hand will probably drive me mad.

    So my question is: Is there anyway i can create a macro that will clear the same cells within a selected area?

    If i select B2:AL3 i like to clear K2, S2:V2, AE2, K3, S3:V3 and AF3. But here i want it to be done in a specific pattern for the selection B2:AL65, C66:AN193 and so on.

    Is it possible?

    Regards

    Kristian
    Attached Files Attached Files

+ Reply to Thread

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