VBA Works Only On The First Time

[Emadu]

Hey all, I'm new to this forum and I need your help please, I'm trying to make a Quote System for my projects/clients. I have an Excel sheet with VBA code, the code is to automatically add a row on a table with clients data if I entered a new client value to a table in a different sheet.

The weird thing is that the code works fine to add a new row and fill it with the needed data, but only for the first time, when I run it again it populate inly the first cell, and when I run it again it gives me error 400.

Please Login or Register  to view this content.

Please help me! the excel sheet is available to download in the attachments for a better view.

thanks in advance

[JLGWhiz]

Try this

Please Login or Register  to view this content.

[Emadu]

Thanks for the reply, the code works good, but I'm still getting the same behavior.

The weird thing is that the code works fine to add a new row and fill it with the needed data, but only for the first time, when I run it again it populate inly the first cell, and when I run it again it gives me error 400.

Thanks a lot.

[JLGWhiz]

I cannot duplicate the condition. The code repeats as expected for me. It could be other event code or formulas in your file that are causing the condition.
Regards, JLG

[jaslake]

Hi Emadu
Welcome to the Forum!!!

• Open your Workbook
• Select "QuotationsDB" worksheet
• Keyboard Ctrl+End

You'll see this in Cell 1048575 Column I...delete it...Code works fine...

2019-02-23_17-58-44.jpg

[Winon]

@ jaslake,

You make me sick!

How the heck, did you come up with that?

Excellent catch, Buddy!

Regards.

[Winon]

@ JLGWhiz,

Come on now. jaslake deserves a Rep tap from you as well my friend!

You were also correct with stating that there must be a problem somewhere else.

Regards.

[jaslake]

Thank you Winon...appreciate the Kudos...

Moved the Code to a Public Module so I could see the Error Code/Description...must have been something messing it up...couldn't find the last row...why not???
Gotta admit...took me a bit...didn't make sense...

2019-02-23_18-38-14.jpg

[Winon]

Clever jaslake!!!

[jaslake]

@Winon
Thanks for the support....School's still out...the OP will be telling us...Solved???...or not???

[Emadu]

WOW, thats weird, I wonder how did this happen.

Thanks a ton sir, I removed the contents, now the code is not crashing. But, still it populates the correct values only the first time.
Explain:
- when I press the Save Quote button it should add a row to the QuotationDB table with the values of K4 to K6.
- what happens now is: when I press the button the first time it will fill all the fields correctly, but after that it'll only fill the first cell of the table.

Thanks again :D

[Fluff13]

How about

Please Login or Register  to view this content.

[Emadu]

Thanks a lot sir :D
it's working fine now.

Thank you all, you're the best.

[Fluff13]

You're welcome & thanks for the feedback