Results 1 to 3 of 3

Thread: [RESOLVED]excel vba question

Threaded View

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Aug 2001
    Posts
    103

    [RESOLVED]excel vba question

    i have an excelsheet with 1 column of data
    column 1 holds numbers from 1 to 100

    I have to check if all numbers from 1 to 100 are in the column

    i.e.:
    1
    2
    3
    5
    6
    7

    number 4 is missing. i have to add a row between 3 and 5 and fill in 4
    it is also possible that more numbers are missing:
    1
    4
    5
    6
    Last edited by newbiekea; Jan 4th, 2006 at 09:26 AM.

Posting Permissions

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



Click Here to Expand Forum to Full Width