Amending basic Macro function

Hello All,

Excuse me from being a noob in this. I have done some basic programming though can't get around this issue. I have had some1 to develop a macro for me that enables me to sort files but I lost contact with that person. One issue I have with this macro is that I want to:

1. Disable the Copy all function (it's too messy and not required)
2. Add 3 or more columns on the left hand side which will include basic text.

Clearly I've tried to manually add the columns then amend the macro script though it seems to come up with a new error everytime i run it. I'm assuming since the range of columns and cells has been changed the macro cannot read it any more. I'm jst not too sure which bit in the macro to change. Can you please let me know which bit in the macro needs amending so I can freely change it?

Thanks.

Hi

I'd start by changing the variable

Please Login or Register  to view this content.

to be
currentCol = 2+however many new columns you add.

So if you add 3 columns, then it would be

Please Login or Register  to view this content.

That said, I do not know what folow on impacts it will have without working through it.

How about you set up a file in the required format, and explain exactly what you want to happen. You mention that you want to get rid of some functionality, so in your explanation, just don't include that aspect.

rylo