Set Rng = Range("S2:S293")
On Mar 1, 8:00*pm, Fan924 wrote:
Sub DataSave()
Dim Rng As Range
Set Rng = Range("S2:S293")
Sheets("Sheet1").Range("C" & Range("A1")).Resize
(Rng.Cells.Count).Value = Rng.Value
* * Beep
* * End Sub
Thanks to your help, this is working nicely.
Trying something new, I am on Sheet2 and I would like to use
Set Rng = Range("S2:S293")
to select cells on Sheet1 and copy to sheet2.
rng.copy destination:=worksheets("Sheet2").range("A1")
|