Row Number Starting From 0
Find bottlenecks in your Excel workbooks
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Row Number Starting From 0

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Can I configure Excel to start from Row 0
    instead of 1.

    Thanks.

  2. #2
    MrExcel MVP Russell Hauf's Avatar
    Join Date
    Feb 2002
    Location
    Portland, OR Area - USA
    Posts
    1,605
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    May I ask why you would want to do this? And personally I don't think there is a way to do this.

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    I have a sheet populated from an oracle
    database.That table has two columns(of many) ,which have parent child relationship.If I want to insert a new record I add a new row, run some macros to protect data integrity as it kind of screws up the whole relationship.Fill other columns and insert into database.
    Now since my column is always off by one hence it creates a little bit of confusion for other users to find what the parent number is, which is actually XLRow number-1.
    First row is used for table columns.

    thnx for your time.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com