change focus of sheets from VB

[butchkmd]

I need to populate some cells in Excel through VB
I origionaly use

Set sht = wb.Sheets("NameOfSheet&quot

then I poulate the cells I need

now I need to change to the next sheet in the workbook.

when I use.

Set sht = wb.Sheets("NextSheet'sName&quot
I don't get an error but my code doesn't populate tcells on the second worksheet.

any suggestions?

Thanks

M

 

[vb5prgrmr]

If I remember correctly you need to do something like...

Sheet.Activate

Good Luck