CatDaddy
06-07-2011, 02:44 PM
to get the row header i use:
Range("B1:H1").Value = colHeader
colHeader being an array of 7 strings, and when i try the same for the row headers:
Range("A2:A31").Value = rowHeader
it copies rowHeader(1) 31 times instead of the 31 different strings in the rowHeader array...
Range("B1:H1").Value = colHeader
colHeader being an array of 7 strings, and when i try the same for the row headers:
Range("A2:A31").Value = rowHeader
it copies rowHeader(1) 31 times instead of the 31 different strings in the rowHeader array...