Helpful Information
 
 
Category: Visual Basic Programming
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).

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.










privacy (GDPR)