Hi I have strange problem with my VBA code where I use

sheet("name").select
cells.copy

I use this code in many other workbooks without any problems but today
I have problem with new workbook I created.
While the code is executing I recive the error: Select method failed
or another error: object oriented error ?

does anywone know what is the problem ?

regards
Peter

Piotr,
Dzien dobre.
maybe you have some merged cells... this makes copy-ing more difficult.

grtx's Martijn

"Piotr" <(E-Mail Removed)> schreef in bericht
news:(E-Mail Removed)...
> Hi I have strange problem with my VBA code where I use
>
> sheet("name").select
> cells.copy
>
> I use this code in many other workbooks without any problems but today
> I have problem with new workbook I created.
> While the code is executing I recive the error: Select method failed
> or another error: object oriented error ?
>
> does anywone know what is the problem ?
>
> regards
> Peter
>

Hi Martijn,
No I dont have any, there is only pivot table in each worksheet as Im
using it for reports distribution.

P.S.
Martijn I see you know polish very well .... pozdrawiam

pozdrawiam
Piotr

I don't know polish very well... tylko troche... ale jest trudno dla
Hollendrem jak mnie...
"Piotr" <(E-Mail Removed)> schreef in bericht
news:(E-Mail Removed)...
> Hi Martijn,
> No I dont have any, there is only pivot table in each worksheet as Im
> using it for reports distribution.
>
> P.S.
> Martijn I see you know polish very well .... pozdrawiam
>
> pozdrawiam
> Piotr
>

Piotr,

Try to run the macro step by step (using F8 in vba).. maybe you can find out
where the mistake is...

grtx's Martijn

"Piotr" <(E-Mail Removed)> schreef in bericht
news:(E-Mail Removed)...
> Hi I have strange problem with my VBA code where I use
>
> sheet("name").select
> cells.copy
>
> I use this code in many other workbooks without any problems but today
> I have problem with new workbook I created.
> While the code is executing I recive the error: Select method failed
> or another error: object oriented error ?
>
> does anywone know what is the problem ?
>
> regards
> Peter
>

I have done so and it alays stops on cells.select
it is very strange as I have exactly same code in other files ?

P.S.
Yes I have tried few worlds "po holendersku" but it was hard too.