#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2002
    Posts
    10
    Rep Power
    0

    visual basic with Excel


    I have an excel worksheet that has 4 columns that need to have data calculated in them, but the user might be inserting other columns between them. Via Visual Basic is there a way that I can track in my code where those columns have moved to? The headers of my 4 columns won't change (the first row of the spreadsheet is the label for each column).

    Comments on this post

    • Gran Roguismo agrees
  2. #2
  3. No Profile Picture
    Sojournor of Lies
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2002
    Location
    Chicago
    Posts
    15
    Rep Power
    0
    Does the title row remain the same and is the title unique. One way then would be to loop across that row looking for the title name and storing that column position.

    Comments on this post

    • Gran Roguismo agrees

IMN logo majestic logo threadwatch logo seochat tools logo