Why Application.CutCopyMode giving problem
Hi Gary,
This is what i did
1. entered fdsfsd in cell B9
2. turned on the Recorder
3. Reselected B9
4. Pressed Cntrl C
'PS at this stage i had a moving border or marquee around the cell
but within seconds it disappeared and i couldnt do paste.
By the way this is on a brand new workbook/sheet with no other workbook
open or VBA in it.
This is what got recorded:
Sub tryy()
Range("B9").Select
Selection.Copy
Application.CutCopyMode = False
Range("B10").Select
End Sub
Very different from yours.
Gary, if i do not have any vba codes in my workbook the copy/cut and
paste performs as it should. But the moment i write a code even if it
is just a blank sub ... end sub with no codes in between; i am unable
to use the paste.
Pls excuse me, i am in Zambia Africa on dial up. I have discussed with
a number of IT chaps here but no luck. will catch up with U tomorrow.
Mny thks and rgds K
|