error 400

[JoeBo]

I open a workbook with vba, I then wish to copy data from the sheet to the
host workbook. This works fine until I attempt to select a range in the
opened sheet:

Workbooks.Open FileName:=FileName


Windows(FileName).Activate
Range("B7:E18").Select

The range select causes an error 400. Is this because the I am not opening
the file with read write permissions?
Anyone help with this.
Thanks
--
JoeBo

[JoeBo]

Found the answer.
I was not specifying the sheet. instead of

Range("B7:E18").Select
I should have put:

ActiveSheet.Range("B7:E18").Select


"JoeBo" wrote:

> I open a workbook with vba, I then wish to copy data from the sheet to the
> host workbook. This works fine until I attempt to select a range in the
> opened sheet:
>
> Workbooks.Open FileName:=FileName
>
>
> Windows(FileName).Activate
> Range("B7:E18").Select
>
> The range select causes an error 400. Is this because the I am not opening
> the file with read write permissions?
> Anyone help with this.
> Thanks
> --
> JoeBo

[sjoh1013]

I had an error 400 problem because i was trying to alter a hidden sheet - the error no longer appeared when i unhid it.