Prevost
Board Regular
- Joined
- Jan 23, 2014
- Messages
- 198
Hi There. I believe I had this working last week but I cannot remember what I had (or if it actually worked as I wanted it). I want to assign cell values in a non-continuous range, to other cells in a non-continuous range. The code should show exactly what I want to do. I want the values of cells B1, B3 and B5 to equal the values of cells A1, A3, and A5 respectively.
Thanks!
Thanks!
Code:
Sub test()
Range("b1,b3,b5").Value = Range("a1,a3,a5").Value
End Sub