ststern45
Well-known Member
- Joined
- Sep 17, 2005
- Messages
- 970
- Office Version
- 365
- 2010
- Platform
- Windows
Hi everyone,
Need help creating VBA code to copy and past a cell range to another cell.
For example,
Cell A1 = 001
Cell A2 = 101
Cell A3 = 365
I would like to copy, paste and transpose cell range A1:A3 to cell range B1 keeping the same format.
For example, B1 would look like the following: 001,101,365 (place commas between the sets)
Thank you in advance!!
Need help creating VBA code to copy and past a cell range to another cell.
For example,
Cell A1 = 001
Cell A2 = 101
Cell A3 = 365
I would like to copy, paste and transpose cell range A1:A3 to cell range B1 keeping the same format.
For example, B1 would look like the following: 001,101,365 (place commas between the sets)
Thank you in advance!!