열전체

https://www.mrexcel.com/forum/excel-questions/937832-vba-code-copy-range-paste-values.html

Sheets("Variables").Range("B5").Resize(.Range("F2:F" & x.Row - 1).Count).Value = .Range("F2:F" & x.Row - 1).Value