Subscript Out Of Range Error 9

[marthadanielle]

Hi All

I have written a Macro and I am not an expert at excel things so please assist. I am getting a subscript out of range error and when I go into the code it see below

Untitled.jpg

How can I fix this?

[arlu1201]

You need to write the code as

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[Thalassa]

Try

Please Login or Register  to view this content.

[marthadanielle]

Now I am getting the below error

Untitled.jpg

[marthadanielle]

As I am pretty useless when it comes to reading code can you direct me towards anyone that I could possibly sent me file to and send my macro to and they can try to run it and see if they can fix the bugs?? I am close to tears at this stage

[arlu1201]

Why dont you upload a sample file here ? The format should be the same as your original, just ensure you remove sensitive data.

Put the code here as well using the code tags.

[Thalassa]

Maybe

Please Login or Register  to view this content.

[marthadanielle]

Ok.. here is the file with the information needed to be edited.

Copy of Quote Log (2).xlsx

And this is a copy of the macro

e&m.xlsm

[arlu1201]

Can you summarize what your code is trying to do, so i can help you correct it?

[marthadanielle]

It is eventually trying to look like this.... or close to it....


test vnhgc.xlsx

[arlu1201]

Your main data in the Copy of Quote log and Test Vnhgc looks the same. Which parts of the file are you trying to automate?

[marthadanielle]

The macro I am creating is automating the editing and structure of the file..
The information remains the same but it is more refined and edited and sheets and formula's are inserted.

[arlu1201]

It will be good if you specify which parts (which cell ranges in which sheets)?