Consulting

Results 1 to 5 of 5

Thread: VBA To Insert A new Row with Specific formatting

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 07-24-2021, 01:56 AM #1
    simora
    simora is offline
    VBAX Mentor
    Joined
    Jan 2008
    Posts
    384
    Location

    VBA To Insert A new Row with Specific formatting

    I am trying to insert a new row into a worksheet, but after inserting the row,
    I want to change the new Row Interior.ColorIndex = 0 for Columns H to S only.
    I don't want to change the rest of the formatting.

    How do I code this so that I don't change the rest of that Row.
    This is how I'm inserting my new row.

    ActiveCell.Offset(1).EntireRow.Insert
    Last edited by Paul_Hossler; 07-24-2021 at 05:06 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules