Cells.copy problem

P

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
 
M

Martijn

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

grtx's Martijn
 
P

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
 
M

Martijn

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

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
 
P

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