Data Disappearing into the twilight zone, Copy Cells marco mystery

i have the following code

Please Login or Register  to view this content.

as stated in code "Invoice" is sheet 15 and "Invoice Database" is sheet 16. the code does not throw up any errors but when i go to look at the "Invoice Database" in the copied information is nowhere to be found hence "Twilight Zone".

i need the information to start entering on cell B19:F19 then as the invoices are produced they create a Database list.

ok i had a little play around on the invoice sheet itself and adjusted the range called "Invoice" and its now showing up on the Database sheet but i need the data to go into B18 then next invoice would go into B19 etc etc but i also have another issue of its throwing up an error and highlighting with ants my "invoice Range".

im really not sure whats going on here. could someone please assist me.

also im offset "invoice" in not working correctly (Name Manager)

i did the step through and it skips this part of the code

Please Login or Register  to view this content.

ive managed to stop the error however i cant get the data destination correct it sitting in Cols R27:V27 instead of B19:F19 down

ok managed to get it to paiste to the right place now it just no offsetting correctly it just over writing what is already there

thank you.

I stand to be corrected here by excel minds much greater than mine, which is not hard.
If you fully qualify your code with something like the code below, you should have a lot less or no problems with the results going west.
There are other ways of doing the qualifying, but I find this way more readable, especially when coming back to it after a period of time.
I once spent ages formatting a sheet only for me to destroy it in a blink of an eye when I had things go wrong in a big way. Qualifying
my code sorted that out. By using a variable name for a worksheet in your code you can give than sheet any tab name you like & change it at will & it won't affect the macro. If you treat excel as if it's as thick as 2 short planks & has to be told exactly what to do, you
shouldn't go wrong.

Please Login or Register  to view this content.