+ Reply to Thread
Results 1 to 3 of 3

Incrementing numbers in a column

  1. #1
    Forum Contributor
    Join Date
    01-06-2019
    Location
    Australia
    MS-Off Ver
    2019
    Posts
    176

    Incrementing numbers in a column

    hello I have a cell value that holds how many rows I want.

    I then in D:D minus top row want to put numbers in from 1 to the value that is in the cell say B10.

    So it has a column of numbers from 1 to the value in B10 in row D.
    Also I would also like to change the background of the cells in D:D minus top row to Blue and text to white



    Please Login or Register  to view this content.
    Thank you for any help much appreciated

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    16,582

    Re: Incrementing numbers in a column

    I use the following to insert numbers in a spreadsheet.
    Please Login or Register  to view this content.

  3. #3
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    Excel 2007
    Posts
    6,366

    Re: Incrementing numbers in a column

    How about this.

    Please Login or Register  to view this content.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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