Weird behaviour of column copy

Hello everybody
I have this code in workbook open

Please Login or Register  to view this content.

The code is supposed to copy the contents of column AH to AM

The sheet4 is hidden .. the code would make it visible and after the copy of column AH it would be hidden
The weird behaviour I stated is that AM column have no data..
The data copied to column BT

I Fixed it
thanks

Please Login or Register  to view this content.

Not sure what you are trying to do. But this

Please Login or Register  to view this content.

would be the entire column AM ... you are trying to resize from row 1 to the number of rows.

However, this:

Please Login or Register  to view this content.

means you are trying to refer to column AM in relation to column AH. The dot (.) links .Range("AM1").Resize(.Rows.Count, 1).Value = .Value to .Range("AH1", .Cells(.Rows.Count, "AH").End(xlUp)) which, in turn, is linked to Sheet4. So, in this case, .Range("AM1").Resize(.Rows.Count, 1).Value = .Value means .Range("AM1").Resize(48, 1).Value = .Value and:

Please Login or Register  to view this content.

It's column BT because that is column AM relative to column AH.

If you explain what it is you intended, I'm sure we can help.

Possibly this:

Please Login or Register  to view this content.

Regards, TMS

Thanks Mr TMS for your great help
I stated that I would copy column AH to AM

so after little modification of yours it worked perfect

Please Login or Register  to view this content.

You're welcome. Thanks for the rep.