VBA Copy won't work

[Roy_Excel_Island_Apps]

Hi guys!

When performing a sht.Range("A1").copy or a Rows(4).copy or whatever... there are no marching ants to see... There is no problem when I do it manually.
Can't see what's the problem here...

Anyone of you who has a clue?

Regards, Roy

 

[Alex Blakenburg]

Do you have the prefix "sht." in front or your rows command as well ?
Check what sheet the value sht is pointing to in the code
or
Put a breakpoint on that line and in the immediate window type
? sht.name
I am expecting it to be different then the sheet your are looking at to see the marching ants

 

[Roy_Excel_Island_Apps]

Do you have the prefix "sht." in front or your rows command as well ?
Check what sheet the value sht is pointing to in the code
or
Put a breakpoint on that line and in the immediate window type
? sht.name
I am expecting it to be different then the sheet your are looking at to see the marching ants

Thanks for your answer Alex!
I just found out that the copy was doing OK, but couldn't see marching ants because screenupdate was FALSE.
The paste wasn't working because I was using PASTE instead op PASTESPECIAL. So pastespecial was the key for some reason.

 

[Alex Blakenburg]

I actually tested with ScreenUpdating = False and the Marching ants were still visible.
To do a straight copy paste (which will includes formulas) you can put it all on one line.

Range("A1").Copy Range("B1")

 

[Roy_Excel_Island_Apps]

I actually tested with ScreenUpdating = False and the Marching ants were still visible.
To do a full copy paste (which will include formulas) put it all on one line.

Range("A1").Copy Range("B1")

Hmmm in that case I still wonder what made it work... Excel is being weird sometimes xD Thanks for your help!

 

[Alex Blakenburg]

Hmmm in that case I still wonder what made it work

If you had the paste on a separate line then you are quite correct it needs to be PasteSpecial.