+ Reply to Thread
Results 1 to 2 of 2

Inserting Rows as a title

  1. #1
    Forum Contributor
    Join Date
    04-23-2007
    Location
    Texas
    Posts
    417
    How do I insert a row with A-N Merged and centered? Interior color should be dark blue with white font.

    Currently I'm doing this to add a space based on a number I have in a column S.

    Please Login or Register  to view this content.
    In column S I have a series of numbers 1 - 5 and when a unique number is found Insert this row I can't seem to figure out how to create...
    Please Login or Register  to view this content.
    Last edited by Tortus; 06-25-2014 at 02:25 PM. Reason: Solved this one myself with offset blanks

  2. #2
    Forum Contributor
    Join Date
    04-23-2007
    Location
    Texas
    Posts
    417

    Re: Inserting Rows as a title

    I don't think I explained that very well. What I am trying to do is insert a row based on a number value in column S. The row should insert with cell A-M merged and centered. This code works but doesn't merge and center A-M

    Please Login or Register  to view this content.
    Whatever the number value is in column S would dictate what is the text in the added row. like a title. The number in S is 1, 2 , 3 , 4, -- 10

+ 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. Replies: 0
    Last Post: 05-20-2014, 11:58 AM
  2. How to Insert a Title When Using an Inserting New Column Macro
    By Jrub in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-21-2013, 11:44 AM
  3. loop through rows for match insert blank rows with title
    By reeyu in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-27-2012, 07:34 AM
  4. Replies: 5
    Last Post: 11-12-2008, 05:44 AM
  5. Inserting multiple rows in excel with data in consecutive rows
    By technotronic in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-20-2005, 11:05 AM

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