Run-time error '1004,
 

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


--
Dave

--
Dave

Run-time error '1004,
 

Hi Davey,

Where is your code housed?


---
Regards,
Norman



"DaveyJones" wrote in message
...
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


--
Dave

--
Dave

Run-time error '1004,
 

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.
--
Dave


"Norman Jones" wrote:

Hi Davey,

Where is your code housed?


---
Regards,
Norman



"DaveyJones" wrote in message
...
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


--
Dave

--
Dave

Run-time error '1004,
 

Hi Davey,

Try moving your code to a Standard module.

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


---
Regards,
Norman



"DaveyJones" wrote in message
...
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.
--
Dave


"Norman Jones" wrote:

Hi Davey,

Where is your code housed?


---
Regards,
Norman



"DaveyJones" wrote in message
...
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


--
Dave

--
Dave