run time error 1004

D

DaveyJones

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
 
D

DaveyJones

Sorry, Don't know why it ended up in access database. I'm sure I changed uit
to excel, don't worry bout it.
 
Top