Copy Selected Columns to Same Sheet

There is something wrong with the declaration statement -

Please Login or Register  to view this content.

I am not sure you can do it this way.
Can you attach a sample workbook with the details of what you need copied and to where? Maybe someone here can help you with an alternate code.

Please provide the details on what data should be copied to which headers.

I am sure they will be better ways of doing this (considering all the experts we have here) but this is one of them:

Please Login or Register  to view this content.

Hi Arlu1201. I'll try this out. Just from reading it, it looks like it will work. I like the FIND function. It's one of the few parts of VBA that I understand. Like you said, there may be a more elegant way to do this, but your code will get it done I think. I'll get back to you as soon as I run it. By the way, do you ever sleep :-).

Hi Arlu. I inserted the code into a module and ran it. I got an error. When I step through the code with F8, I get the following error when it reaches the first line that reads "cellcol = ActiveCell.Column".

Compile error:
Variable not defined

I tried to dimension the variable cellcol as range = to ActiveCell.Column, but that didn't work. I think I mentioned that I'm very new to this so I'm not sure what to do next. Any help you can provide is appreciated. Thanks.

rgerart

Hi Arlu.

I just dimensioned cellcol as Integer and the program worked!!! Thank you so very much for you help. I really appreciate all the effort you put into this. Thank you.

rgerard

I do sleep when you are awake, since you are in US and i am in India.

I guess you have "Option Explicit" mentioned at the top of your code, which makes it mandatory for all variables to be defined. Its a good way of coding, however i had to do something quick so didnt define the variables.

Incase cellcol gives you an error (since you have defined it as integer) you can then change it to Long. (Dim cellcol as long).