Cells.copy problem

[Piotr]

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

 

[Martijn]

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

grtx's Martijn

 

[Piotr]

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

 

[Martijn]

I don't know polish very well... tylko troche... ale jest trudno dla
Hollendrem jak mnie...

 

[Martijn]

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]

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.