VBA get the cell value in a cell that is on the same row.

[decadence]

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

        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>

 

[Fluff]

How about

Set rng = rng.Resize(Cells(Rows.Count, rng.Column).End(xlUp).Row)
rng.Copy Range("AA" & rng.Row)

 

[decadence]

This is perfect thanks Fluff

 

[Fluff]

Glad to help & thanks for the feedback