Nachtschade
New Member
- Joined
- Dec 6, 2013
- Messages
- 30
Hi there,
I'm sure this is possible. I am trying to copy the values of range k31:k54 to another range (x). Range x changes and is noted in cell s66. Currently s66 has
<tbody>
</tbody>as it's value.
So the vba action needs to copy everything from k31:k54 to cr2:cr25.
I've tried this:
I'm sure I'm (somewhat) close but I don't know what I should change. Can anyone shed a light?
I'm sure this is possible. I am trying to copy the values of range k31:k54 to another range (x). Range x changes and is noted in cell s66. Currently s66 has
cr2:cr25 |
<tbody>
</tbody>
So the vba action needs to copy everything from k31:k54 to cr2:cr25.
I've tried this:
Code:
Sub actie()
Dim val As String
val = Range("s66").Value
Range.val = Range("k31:aw54").Value
Application.Calculate
End Sub
I'm sure I'm (somewhat) close but I don't know what I should change. Can anyone shed a light?
Last edited: