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

Hi Davey,

Where is your code housed?


---
Regards,
Norman



"DaveyJones" <dmlong05/yougettheidea/@hotmail.co.uk> wrote in message
news:903CE3AF-D408-4938-B06D-A41B906A8651@microsoft.com...
> 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

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" <dmlong05/yougettheidea/@hotmail.co.uk> wrote in message
> news:903CE3AF-D408-4938-B06D-A41B906A8651@microsoft.com...
> > 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
>
>
>

Hi Davey,

Try moving your code to a Standard module.

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


---
Regards,
Norman



"DaveyJones" <dmlong05/yougettheidea/@hotmail.co.uk> wrote in message
news:48804C26-33BD-4EBA-A647-477C684B031C@microsoft.com...
> 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" <dmlong05/yougettheidea/@hotmail.co.uk> wrote in message
>> news:903CE3AF-D408-4938-B06D-A41B906A8651@microsoft.com...
>> > 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
>>
>>
>>