lcfc2kotmail
02-02-2008, 03:38 AM
Hi I have a loop within my main program
For i = 1 To 10
For j = 1 To 20
Worksheets(2).Cells(1, i) = arraya(i)
Worksheets(2).Cells(j + 1, i) = arrayb(i,j)
Next j
Next i
hi this loop works and outputs my data as needed from my 2 arrays, arraya contains a string of names and arrayb contains data.
However I want to while its outputtingthese to make the names autofit in the columns across and also make them bold(i.e. the first cells statemnt)
From the second statement where it outputs the data, I would like this data to be centred and to 2DP, many thanks if anybody could suggested anything
For i = 1 To 10
For j = 1 To 20
Worksheets(2).Cells(1, i) = arraya(i)
Worksheets(2).Cells(j + 1, i) = arrayb(i,j)
Next j
Next i
hi this loop works and outputs my data as needed from my 2 arrays, arraya contains a string of names and arrayb contains data.
However I want to while its outputtingthese to make the names autofit in the columns across and also make them bold(i.e. the first cells statemnt)
From the second statement where it outputs the data, I would like this data to be centred and to 2DP, many thanks if anybody could suggested anything