Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why is Application.CutCopyMode False? | Excel Programming | |||
Application.DisplayFormulaBar Kills CutCopyMode | Excel Programming | |||
Cutcopymode problem | Excel Programming | |||
Hidden hyperlinks giving me a problem... | Excel Programming | |||
CopyPicture is giving problem | Excel Programming |