I basically want to loop through the header of a current region, save the header names into an array. Later I will use these values to assign names to the columns. THis code is supposed to store all of the names in the headerrange in an array of headname. To set the size of the array, I've used the number of columns. My first error is for the Set headercols = headers.columns.Count. it says an object is required. I'm not certain what to do right now. I'm learning on the fly a bit so. The rang for the header works, although I know its not a very elegant solution. My questions is how to get this loop going so I can store the values in the array. help would be much appreciated.Please Login or Register to view this content.
Bookmarks