Hi can anyone help?
I am copying data from "AJ2:AS & lRowAJ" to "N2:W & lRowAJ" and "X2:AG & lRowAJ"
If I use the following line it copies fine
[CODE
.Range("AJ2:AS" & lRowAJ).Copy
.Range("N2:W" & lRowAJ, "X2:AG" & lRowAJ).PasteSpecial Paste:=xlPasteValues][/CODE]
I would prefer to use the following line but I get errors in "X2:AG" is there something I can add to this line to have it equal the values in "AJ:AS"
[CODE
.Range("N2:W" & lRowAJ, "X2:AG" & lRowAJ) = .Range("AJ2:AS" & lRowAJ).Value][/CODE]
ie
<tbody>
</tbody>
Regards
pwill
I am copying data from "AJ2:AS & lRowAJ" to "N2:W & lRowAJ" and "X2:AG & lRowAJ"
If I use the following line it copies fine
[CODE
.Range("AJ2:AS" & lRowAJ).Copy
.Range("N2:W" & lRowAJ, "X2:AG" & lRowAJ).PasteSpecial Paste:=xlPasteValues][/CODE]
I would prefer to use the following line but I get errors in "X2:AG" is there something I can add to this line to have it equal the values in "AJ:AS"
[CODE
.Range("N2:W" & lRowAJ, "X2:AG" & lRowAJ) = .Range("AJ2:AS" & lRowAJ).Value][/CODE]
ie
N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | AI | AJ | AK | AL | AM | AN | AO | AP | AQ | AR | AS | |
1 | Nxt | Nxt | Nxt | Nxt | Nxt | Nxt | Nxt | Nxt | Nxt | Nxt | Nxt | Nxt | Nxt | Nxt | Nxt | Nxt | Nxt | Nxt | Nxt | Nxt | Nxt | Nxt | Nxt | Nxt | Nxt | Nxt | Nxt | Nxt | Nxt | Nxt | Nxt | Nxt |
2 | 10 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 1 | #N/A | ### | ### | ### | ### | ### | ### | ### | #N/A | #N/A | 10 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 1 | ||||
3 | ||||||||||||||||||||||||||||||||
4 | ||||||||||||||||||||||||||||||||
5 | ||||||||||||||||||||||||||||||||
6 | ||||||||||||||||||||||||||||||||
7 | ||||||||||||||||||||||||||||||||
8 | ||||||||||||||||||||||||||||||||
9 | ||||||||||||||||||||||||||||||||
10 |
<tbody>
</tbody>
Regards
pwill
Last edited: