a few simple questions from a noob

[raj]

1.
In my spreadsheet my first row is a header row (i.e. it gives meaningful
name to each column)
How can i get a column by its column header?

right now i use the Letter of the column, convert the letter to a number and
then use mySheet.Cells(x, y)
i would like to make it so i can say
mysheet.Cells(x, GetColByName("LOBID")) or something like that


2. The rows are records. ineed to transform each record and resave it
somewhere else
How can i
a. Read a row
b. traverse throgh the row that i just read (meaning how can i refer
to the row i read and get to the column i need to modify)
c. and modify the value of a column in the row.
d. take the modified row and save it in another spreadsheet.

or whats a best way to perform tranformation of data row by row?

thanks