why copy and paste doesn't work if macro is running?

[earp_]

Hi, I have my macro that every second does a copy and paste.
but window doesn't copy and paste anything else but the macro's value
is it normal?

 

[earp_]

my macro every second does this:

myValue.Copy
Worksheets("Sheet2").Range(colSheet2).End(xlUp).Offset(1, 0).PasteSpecial xlValues

Now, if the macro is running, and I open any program, notepad, IE, firefox, and I copy a part of a text and paste into a notepad I'm not able to copy any text and it pastes only myValue, it looks like excell keeps the memory somehow.

Any suggests?

 

[GlennUK]

Excel's Copy and Paste uses the Clipboard just like any windows applications use the Clipboard.

Have you thought about reprogramming your VBA to not use Copy?

 

[earp_]

ah, that would be very interesting, but i have no idea how i can do that.
How can i copy a value if i can't copy and paste it?

 

[GlennUK]

Like this:

Range("Z1:AL14").Value = Range("A1:M14").Value

 

[earp_]

Like this:

Range("Z1:AL14").Value = Range("A1:M14").Value

Can I do that for this

myvalue.Copy
Worksheets("Sheet2").Range(colSheet2).End(xlUp).Offset(1, 0).PasteSpecial xlValues

?

 

[GlennUK]

What is myvalue? A single cell? A range?

Guessing here but would this work:

Worksheets("Sheet2").Range(colSheet2).End(xlUp).Offset(1, 0).Resize(myvalue.Rows.Count,myvalue.Columns.Count).Value=myvalue.Value

?

 

[earp_]

What is myvalue? A single cell? A range?

Guessing here but would this work:

Worksheets("Sheet2").Range(colSheet2).End(xlUp).Offset(1, 0).Resize(myvalue.Rows.Count,myvalue.Columns.Count).Value=myvalue.Value

?

...I forgot...

myValue = Worksheets("Sheet1").Range("B2")

 

[GlennUK]

Then this should work:

Worksheets("Sheet2").Range(colSheet2).End(xlUp).Offset(1, 0).Value=myvalue

 

[earp_]

that is great, thanks a million!