Hi,

In VBA I have a for loop that adds multiple sheets. At the end I want to
add a final sheet that is situated in the beginning. I tried this VBA code
but when I looked at the file, a new sheet was created but was not populated
with data. I know that you have to activate the sheet somehow, but I must be
losing memory as I forgot how to. Any help is appreciated.

This is what I have now.

Worksheets.Add befo=Sheets(1)
Sheets(1).Select

Range("A1").Value = "Sector"
Range("A2").Value = "3/31/2006"

......