Results 1 to 3 of 3

Thread: Remove fill

  1. #1
    3 Star Lounger
    Join Date
    May 2003
    Location
    Mid-Cheshire, England
    Posts
    275
    Thanks
    1
    Thanked 3 Times in 3 Posts
    I need to remove fill from multiple every other rows.

    To create the rows I used this routine I found on the Internet at www.ozgrid.com:

    Sub insertEveryOtherRow()

    Do While Selection <> ""
    Selection.EntireRow.Insert
    Selection.Offset(3, 0).Select
    Loop

    End Sub

    In hindsight I should have have had something to stop the formatting of the previous row being copied into the inserted row. However it's a bit late for that now and in any event beyond my competence.

    Perhaps a kind Lounger would offer me assistance that would be most gratefully received.

    Malcolm

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You should be able to modify the following macro:

    Code:
    Sub FixFormatting()
      Dim r As Long
      ' Adjust the lower and upper bounds as needed
      For r = 1 To 100 Step 3
    	Rows(r).ClearFormats
      Next r
    End Sub
    Change the values 1 and 100 to what you need.

  3. #3
    3 Star Lounger
    Join Date
    May 2003
    Location
    Mid-Cheshire, England
    Posts
    275
    Thanks
    1
    Thanked 3 Times in 3 Posts
    [quote name='HansV' post='784084' date='10-Jul-2009 22:51']You should be able to modify the following macro:

    Code:
    Sub FixFormatting()
      Dim r As Long
      ' Adjust the lower and upper bounds as needed
      For r = 1 To 100 Step 3
    	Rows(r).ClearFormats
      Next r
    End Sub
    Change the values 1 and 100 to what you need.[/quote]

    Hans,

    Thank you for your help and rapid response. I was able to suitably modify the routine and use it successfully.

    I am grateful indeed,

    Malcolm

Posting Permissions

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