Issue with selecting columns via macros

Instead of using Select/Selection try explicitly referring to the column(s).

Which column(s) do you want to format?

Please Login or Register  to view this content.

Obviously, this is a recorded macro.
I can reduce your code, but I'm still not sure what you are trying to accomplish.
You have this line of code ->> Selection.EntireRow.Delete
What row are you deleting? Because as the code is written, it will delete the same row where the data was just pasted.

Here's a slight mod to your code (it can be reduced further), but we'd like to know wht you are trying to do so you get what you need.

Please Login or Register  to view this content.

Thanks Jim & Norie for your quick replies! I really appreciate it.

From your comments I managed to trim my code right down and get it to work. The "select" function seemed to be causing a lot of grief but the last time I used this piece of code I had no problems.

What I was trying to do was copy a chunk of data from one sheet to another then remove the header, this data would vary in length but would always be contiguous.
Then I wanted to change the format of one of the columns.

Please Login or Register  to view this content.

OK.
Glad you got it solved.