Hi

I thought this was going to be easy but I am stuck.

I want to execute a for loop from one sheet, going through data in another sheet. I have tried to set the sheet to be looped as active but my loop only looks in the sheet I am executing the loop from. how do I do this?

this is my code (simplyfied). sub cmd_load_click is located in sheet "summary. same workbook.

Private Sub Cmd_load_Click()

Dim i As Integer


Worksheets("IT").Activate

For i = 1 To 7
MsgBox (Cells(i, 1))
Next i


End Sub