decadence
Well-known Member
- Joined
- Oct 9, 2015
- Messages
- 525
- Office Version
- 365
- 2016
- 2013
- 2010
- 2007
- Platform
- Windows
Hi, Is it possible to copy or get the cell value from a set range of cells which is a variable to a static range of cells that will never change but on the same row.
I am using this for my range variable but Columns("AA:AA") will be the static range
Example 1:
Form this
<tbody>
</tbody>
To this
<tbody>
</tbody>
Example 2:
From this
<tbody>
</tbody>
To this
<tbody>
</tbody>
I am using this for my range variable but Columns("AA:AA") will be the static range
Code:
Set Rng = Rng.Resize(Cells(Rows.Count, Rng.Column).End(xlUp).Row)
Example 1:
Form this
A | B | |
1 | ||
2 | ||
3 | Cell Value 1 | |
4 | Cell Value 2 |
<tbody>
</tbody>
To this
AA | |
1 | |
2 | |
3 | Cell Value 1 |
4 | Cell Value 2 |
<tbody>
</tbody>
Example 2:
From this
A | B | C | |
1 | |||
2 | Cell Value 1 | ||
3 | Cell Value 2 | ||
4 | Cell Value 3 |
<tbody>
</tbody>
To this
AA | |
1 | |
2 | Cell Value 1 |
3 | Cell Value 2 |
4 | Cell Value 3 |
<tbody>
</tbody>
Last edited: