copy last column

[Abroza]

Hi,
I need a vba code for selecting the last column with data in the file and copying it to a different column in a different sheet : sheet 3 column A
thanks

[vijay2482]

Hi,

Is the last column in the file always the same?
If so, which column is it?

[vijay2482]

Assuming your selection range is B1:B50

Please Login or Register  to view this content.

[Shijesh Kumar]

Try this

Please Login or Register  to view this content.

[Abroza]

the column isn't the same, it changes so I can't use the code you gave me.
I tryed this code, I don't know why but it select the first column with data (A) and no the last one,
can someonee look at this and help:

Please Login or Register  to view this content.

thanks

[vijay2482]

Please Login or Register  to view this content.

in the above code End(xlToLeft) has to be changed to End(xlToRight), but it will give you the last column of your sheet.
you will have to specify the usedrange of the sheet to get the desired output.

[vijay2482]

Abroza,

I executed the code, that you have posted and found that it works fine.
Do not replace left to right.

Vijay

[Abroza]

for me it still selects the first column A, all the way to the last row, instead of selecting the last column all the way to the last row!
any suggestions?

[vijay2482]

Abroze,

I found that Shijesh Kumar's code does what you need.
Check it out.

Vijay

[vijay2482]

please attach the work book you are using.

[Abroza]

I found the problem, something was messed up with my data in my workbook and it couldn't identify the last column, now it work great with my code!
thanks!

[vijay2482]

Arboze,

Mark your post solved.