|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Dell PowerEdge Servers
|
|
#1
December 19th, 2002, 01:18 AM
|
|||
|
|||
|
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).
|
|
#2
December 19th, 2002, 10:45 PM
|
|||
|
|||
|
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.
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > Visual Basic Programming > visual basic with Excel |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
