which sheet a loop is valid for-how do you know?

G

Guest

How do I know which sheet the loop refers to / is valid for? According to my
logic it should be previous sheet, but it seems it is the other sheet (start
here)? Not logical as I select the previous sheet just before the loop starts.

Sheets("start here!").Activate
ActiveSheet.Previous.Select

x = 2

Do While Cells(x, 2).Value <> ""

Cells(x, 9) = Application.VLookup(Cells(x, 8),
Worksheets("Prognos").Range("A1:B50000"), 2, False)

x = x + 1

Loop

End Sub
 
G

Guest

In a general module, you would be correct.

I suspect this is in the worksheet module of the sheet "Start Here!" where
unqualified references are to the sheet containing the code, not the
activesheet.

Qualify your references or move the code to a general module and call it
from the worksheet module (if necessary)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top