finalcolumn?

[xtscars]

I'm trying to paste something in the final column +1. right now I have: finalcolumn=Range("XFD1").End(xlToLeft).Column

so if I understand it, I have just defined what "finalcolumn" means, right? So now that it's defined, how do I actually use it? Range("finalcolumn")? Super confused. Thanks!

 

[Weaver]

try

columns(finalcolumn).copy

 

[Rasm]

This will allow you to pick ranges - but if you want entire column this may not help

Worksheets("Sheet1").Range(RangeSource).Cut
Worksheets("Sheet1").Paste Destination:=Worksheets("Product_Codes").Range(RangeDestination)

 

[xtscars]

Sir, if my sheet looks something below, what will the columns(finalcolumn).copy comman copy? will it copy d? c? for some reason my sheet is copying b.

a b c d
1 x x x
2 x x x x
2 x x x x
4 x x x