Iterate through alphabet? 1

[Paladyr]

I want to put this into a Do while loop:

SUM(A3:A(intRec))
and next time around it should be:
SUM(B3:B(intRec))

Is there anyway to loop through the column headings in excel so that I can do this (other then creating an array with all the letters in it)?? Is there a way to do this using .Cells? Thanks!

 

[Paladyr]

Well, I suppose i could use the ascii value to do it. NM, I can do that, thanks anyway!

 

[Paladyr]

Actually that's going to be tough once I reach the two character column headings. Is there a way to loop through the excel column headings???

 

[Paladyr]

Nevermind, I think I can just setcurrent on a cell, then return the range to figure out where I am, then use that range to plop it into the fomula. SAWEEEET!!!!!!

 

[logius]

Uhhh... good job? :-I ----------------------------------------
If you are reading this, then you have read too far...

lightwarrior@hotmail.com