Ending Macros

[lj123]

I have a macro that continues to tell me that an End With and/or End Sub is expected. I continue to add these statements in various ways, but the macro will not complete properly.

Here is the code:

Please Login or Register  to view this content.

What is the proper order / format for these statements?

[Shijesh Kumar]

Hi

there are two With Statement , so you require two End With....

So you require one more End With... that should be placed before second with

Please Login or Register  to view this content.

[lj123]

Thank you for that information but i am still having trouble. The problem may be that several people have offered advice on improving this macro but i have only included parts of the macro each time. Now I think i need advice on the macro as a whole. The whole macro is provided below. What I am trying to accomplish it copy many parts of a purchase order to a master customer database. the purchase order is File 1 and the Customer database is File 2.

I feel like there is a lot of extra steps in this macro preventing it from working. This is a long macro, but there are a lot of individual cells in File 1 that need to be copied to individual cells in File 2. Any help would be appreciated.

Please Login or Register  to view this content.

[JBeaucaire]

I'd recommend something a little more direct and easier. Just copy the values directly using the format

[destination].Value = [source].Value

Please Login or Register  to view this content.

[JBeaucaire]

By the way, as I changed the format of your macro I spotted TWO typos in your macro that would cause problems.

Please Login or Register  to view this content.

Notice the extra period. And...

Please Login or Register  to view this content.

Notice the missing "3".

[lj123]

Thank you J that does seem more straight forward and thank you for catching the errors. However when I implemented the code you suggested I receive a Run Time Error '438' Object doesn't support this property or method.

When debugging it highlights the first row that identifies the destination and source. Any thoughts?