You haven't posted your code. Try something like this:


Sub copysample()
Dim r1, r2 As Range
Set r1 = Range("A1")
Set r2 = Range("B2")
r1.Copy r2
End Sub


This works on the active sheet.
--
Gary's Student


"Kieranz" wrote:

Hi
When I start Excel2003, I can copy, cut and then paste. But when I go
to VBE and even just create Sub ... End Sub without any codes and go
back to Excel sheet problems...
I type 'dfsdf' in a cell, and then copy (using Ctrl C, Edit Copy, Copy
icon, right click shortcut menu, tried them all) the moving borders
flashes for a while and then stops. meaning I can't paste. I have a
strange feeling that its something to do with cutcopymode which I used
in another workbook.

Yes I tried Clipboard, which works but without formats and formulas.

Help appreciated
Kieranz