How to stop .End(xlip).Offset(0, 0) at a certain point?

Hello,

I was wondering how I can stop the following macro button, which Works good, to not og any further that to C13. C13 should be the last whereby the code should work. C12 contains heading of table.

Please Login or Register  to view this content.

If it is any help, the content of the cell C12 is "Manufacturer".

Thanks in advance

Originally Posted by Leith Ross

Hello tnuis,

Here is one way to do it...

Please Login or Register  to view this content.

Hmmmm. This one doesnīt work. Nothing happens at all when the macro has this code. Must be something missing here??

Originally Posted by xladept

Maybe:

Please Login or Register  to view this content.

Iīm afraid this one doesnīt work either. Nothing happens when the macro contains only this code. My code does work only it never stops.....

Originally Posted by xladept

Hey tnuis,

It works for me?

Really strange. Here is the Sample workbook. You can choose something from the ComboBox1 and then press the "RESET LAST ROW" button. Now it is running Your code. I just copypasted it strait from Your comment.

Sample Workbook.xlsm

Can you see what Iīm doing wrong?


By the way, I found another solutin that actually does the trick, but itīnot the nicest solution I think but the following code does work (Leverandør = Manufacturer):

Please Login or Register  to view this content.

Originally Posted by xladept

The code works when you have data in Range("AE1:AN1")???

Oh no, I think I havenīt been clear enough. I want the opposite of what your code does. If there is data in the AE1:AN1 then it fills inn THAT data in the first empty ROW in the destination with your code. I entered "bla bla bla" in the cells AE1:AN1 now and whenever the Macro button is hit it fills in bla bla boa in the first empty cell it finds , counting from C41 and up.


What I want is the opposite. I want it to start at C41 and start searching upwards for the first cell that contains a value, and THEN delete that, hence the AE1:AN1 is empty.

My original code in this thread DOES this, BUT my problem is that it will never stop so my whole order template is ruined if button is hit when C13 is empty, coz then it copy pastes the AE1:AN1 into the headers which is C12:L12.

I simply want the code to stop function after C13.

Might I also add that AE1:AN1 contains some formulas that need to be transferred as well. Thatīs why I use the code that I use.


Hope this was clearer

Originally Posted by xladept

Please Login or Register  to view this content.

Aaaaaaahhhhhh. Thatīs the one Everything is working perfect now. Thanks a lot man!!