Glasgowsmile
Active Member
- Joined
- Apr 14, 2018
- Messages
- 280
- Office Version
- 365
- Platform
- Windows
I've got the following formula and I need to add Transpose:=True to it but everything I've tried produces errors. Is there a simple way to do it for this?
Originally I was using .copy with .pastespecial xlpastevalues, transpose=:true but I wanted to see if the below approach would be faster for execution.
Originally I was using .copy with .pastespecial xlpastevalues, transpose=:true but I wanted to see if the below approach would be faster for execution.
VBA Code:
Sheets("Data").Range("Z10, Z14, Z18, Z20") = Sheet1.Range("C" & Rows.Count).End(xlUp).Offset(1).Value