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_]

thank i will try!

 

[earp_]

yep i missed also

.FormulaR1C1

tks

 

[earp_]

for some strange reason this doesn't work always...

If (myColCheck > 11) Then
Worksheets("Sheet3").Range("F" & myColCheck & ":" & "N" & myColCheck).FormulaR1C1 = Worksheets("Sheet3").Range("F11:N11").FormulaR1C1

end if
(myColCheck is greater than 11)

 

[GlennUK]

It what way does it not work? What does it do instead?

 

[earp_]

instead of

=+F10*(1-F$5)+$E11*F$5

it gave me this

=+A65536*(1-A$5)+$E1*A$5

strange because sometimes it works.

 

[GlennUK]

Are you sure that myColCheck is always greater than 11?

You should try to work out under what conditions this fails, and what is different compared to when it works.

 

[earp_]

i put an else MsgBox(myColcheck)
so when it fail i will see it.
thanks again.

 

[earp_]

Hi, I found when that doesn't work: it doesn't when I'm watching a chart Sheet

Worksheets("Sheet2").Range("F" & myColCheck & ":" & "N" & myColCheck).FormulaR1C1 = Worksheets("Sheet2").Range("F11:N11").FormulaR1C1

myColCheck and integer and it is the actual row.
So with this code I create a chart, if i'm on the sheet where the code is made, everything is perfect.
Once i'm on the chart sheet the code doesn't work.
What it could be the reason?
my code has this structure:

With ThisWorkbook
....
....
With Worksheets("Sheet1")
...
Worksheets("Sheet2").Range("F" & myColCheck & ":" & "N" & myColCheck).FormulaR1C1 = Worksheets("Sheet2").Range("F11:N11").FormulaR1C1
End With
..
End With

 

[GlennUK]

Please explain what you mean by "Chart Sheet"? In Excel a chart sheet is an object that is a sheet that just contains a chart ... no rows and no columns. Is that what you've created?

 

[earp_]

yep... i have a sheet which contains a chart and that chart gets the values from Sheet2.
If i'm on sheet2 i have no problem and everything work correctly.
Instead if i'm on the chart sheet the code when is called doesn't work.

Worksheets("Sheet2").Range("F" & myColCheck & ":" & "N" & myColCheck).FormulaR1C1 = Worksheets("Sheet2").Range("F11:N11").FormulaR1C1