tkaplan
07-12-2006, 01:19 PM
it's been a while since i've touched excel vba and i forgot how to do this:
i have a spreadsheet that is based on an exported report and i am trying to format it. however, the fields exported are a differnet number each time, but always in the same format.
so it's always like this:
col A - row headings | ColB and C - plan 1 |
and each additional plan takes another 2 columns.
so i need to figure out how many plans there are.
so i go down to the row that is always filled in in every cell and i did selection.end.
so now here's my question:
say i end on col E, i need to translate that into 5 so that i can subract 1 (for the col a headers) and divide by 2 to figure out that there are 2 plans.
so how do i do this?
thanks in advance,
tkaplan
i have a spreadsheet that is based on an exported report and i am trying to format it. however, the fields exported are a differnet number each time, but always in the same format.
so it's always like this:
col A - row headings | ColB and C - plan 1 |
and each additional plan takes another 2 columns.
so i need to figure out how many plans there are.
so i go down to the row that is always filled in in every cell and i did selection.end.
so now here's my question:
say i end on col E, i need to translate that into 5 so that i can subract 1 (for the col a headers) and divide by 2 to figure out that there are 2 plans.
so how do i do this?
thanks in advance,
tkaplan