variable column formatting

Topics: User Forum
Sep 18, 2011 at 12:59 AM

You all have been such great help before, so thanks in advance.

I'm trying to have the columns detected dynamically...I know the array bit works but is limited:


So what would a loop look like that would detect the number of columns in use?  Columns do have headers in this situation, so the first cell of each column would have data in them.


Thanks again,


Sep 19, 2011 at 12:00 AM

It also seems that I could use GetHighestColumn() in this this correct?