+ Reply to Thread
Results 1 to 2 of 2

Clear Contents of column based on data in another column

  1. #1
    Registered User
    Join Date
    12-23-2013
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    49

    Clear Contents of column based on data in another column

    Hi Guys,

    I need to clear the contents of a columns G and H starting 11th row based on what is there in F column. The macro should check for last non-empty cell in column F starting F11 (assume it finds F30 to be last non-empty cell), then it should clear the contents of G11 to G30, H11 to H30.

    Any help please.

  2. #2
    Registered User
    Join Date
    12-23-2013
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    49

    Re: Clear Contents of column based on data in another column

    Taking above example, after G30, i.e. starting G31 all the cells will be protected (it's a dynamic protection). So, alternatively, if there is a way to write macro to clear content of all cells in column G starting G11 until it hits first protected cell, that will also work. I need not check in column F in that case.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Clear contents of last column with data
    By avanir151 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-28-2014, 03:45 PM
  2. If cell in column contains value, clear contents of another column in the same row
    By Random Thought in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-23-2013, 02:31 PM
  3. Replies: 3
    Last Post: 01-08-2013, 01:27 PM
  4. [SOLVED] How to clear cell contents in a certain column based on set criteria
    By macrohelp5 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-25-2012, 10:41 AM
  5. hide column and clear contents based on a cell value in another sheet
    By dittotharappel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-28-2009, 12:19 PM

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