Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts

    Clear Values (2007)

    I have a spreadheet that contains formulas in column F from row 6 onwards. I want a macro to clear the formulas in column F from the row where the cells are blank in column E from row 6 onwards

    See attached sample-in this example F8 onwards must be cleared as E8 onwards is blank

    Your assistance is much appreciated

    Howard
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Clear Values (2007)

    Try this:

    Sub ClearF()
    Dim m As Long
    Dim n As Long
    m = Cells(Rows.Count, 5).End(xlUp).Row
    n = Cells(Rows.Count, 6).End(xlUp).Row
    Range(Cells(m + 1, 6), Cells(n, 6)).ClearContents
    End Sub

  3. #3
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts

    Re: Clear Values (2007)

    Hi Hans

    Thanks for the help

    Much appreciated

    Regards

    Howard

Posting Permissions

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