Combine sheets - different size n shape
Closed
carman
-
Aug 4, 2010 at 02:31 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 5, 2010 at 07:37 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 5, 2010 at 07:37 AM
Related:
- Combine sheets - different size n shape
- Mtu size calculator - Guide
- Fifa 23 pc download size - Download - Sports
- Convert picture to shape powerpoint - Guide
- Gta 5 size for windows 11 download free - Download - Action and adventure
- Combine notifications viber - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Aug 4, 2010 at 08:40 AM
Aug 4, 2010 at 08:40 AM
Copy what range to what range? by range i mean copy what columns to what column
Aug 4, 2010 at 08:10 PM
Aug 5, 2010 at 07:37 AM
If (lTgtLastRow = 1) Then
Rows("1:" & lSrcMaxRows).Copy
Else
Rows("2:" & lSrcMaxRows).Copy
End If
Make it to copy the range that you would like to copy. This copy the rows
And change this Cells(lTgtLastRow, "A").PasteSpecial
This start pasting at column A. Change it to E