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?

 

[GlennUK]

My pleasure.

 

[earp_]

can you please tell me if this is correct, seems not to work

Worksheets("sheet3").Range("B" & myColCheck & ":" & "E" & myColCheck).Copy Destination:=Worksheets("Sheet4").Range("B" & myColCheck & ":" & "E" & myColCheck)

to

Worksheets("Sheet4").Range("B" & myColCheck & ":" & "E" & myColCheck) = Worksheets("sheet3").Range("B" & myColCheck & ":" & "E" & myColCheck)

myColCheck is a number let's say 15

 

[GlennUK]

You haven't put .Value in at all.

 

[earp_]

I just realized that now!
thanks again

 

[GlennUK]

Good luck! Am logging off now. Might be back on some time over the weekend, and will definitely be back on Monday.

 

[earp_]

Thanks! have a good weekend.

 

[earp_]

instead I guess that if I want to copy the formula that is in a Cell, that won't work anymore, right?

 

[GlennUK]

You just got me before I log off. For a single cell formula copy use .Formula instead of .Value, and see if it does what you want.

You have a good weekend too.

 

[earp_]

Worksheets("Sheet3").Range("B11:E11") = Worksheets("Sheet3").Range("B1:E1").Formula
if in B1 I have this formula

=+F10*(1-F$5)

in B11 i will have the same formula and not

=+F37*(1-F$5)

what i mean is that with copy and paste i adjust also the formula at the cell.
But not in this way,am I right or is there any solution?

 

[GlennUK]

Worksheets("Sheet3").Range("B11:E11") = Worksheets("Sheet3").Range("B1:E1").Formula
if in B1 I have this formula

in B11 i will have the same formula and not

what i mean is that with copy and paste i adjust also the formula at the cell.
But not in this way,am I right or is there any solution?

Sorry about that, was in a hurry and specified Formula instead of FormulaR1C1, as in

Worksheets("Sheet3").Range("B11:E11").FormulaR1C1 = Worksheets("Sheet3").Range("B1:E1").FormulaR1C1