run time error 1004

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Sorry, Don't know why it ended up in access database. I'm sure I changed uit
to excel, don't worry bout it.
 

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

Similar Threads

Run-time error '1004, 3
"Run-time error '1004' 5
Run-time Error '1004' 1
Run-time error '1004' 1
Run-time error 1004 paste method of worksheet class failed 3
Run-time error when copying entire row! 5
Runtime error 1004 after 1st run 4
Selection.AutoFill Destination:=Range 0

Back
Top