Run-time error '1004,

[Guest]

Run-time error '1004,
Select Method of Range class failed.

Can anyone tell me why, the code I was using is

Sheets("Code").Select
Range("B1").Select ####(error is apparently here)####

If ActiveCell = "1" Then GoTo Inputdata
End

and the cell Code!B1 contains

=IF(ISERROR(Data!F1),"1","0")

The help, as usual, tells me diddly squat....
Cheers

 

[Norman Jones]

Hi Davey,

Where is your code housed?

 

[Guest]

Yeah, I've just figured that one out myself, it's in a different worksheet.
If you type a GoTo command for a subroutine in one worksheet, does it look in
another worksheet for it, cos I want all this to run in one go.

 

[Norman Jones]

Hi Davey,

Try moving your code to a Standard module.

Normally, a sheet module shoould only house worksheet event procedures.