Insert argument in code

**kosherboy** · 04-04-2014, 10:06 AM

Hello everyone.
When the below code with this workbook Save_Update Customer.xlsm is hit the customer in sheets "Customer" updates the existing customer in "Sheet1".
Can anyone add to my code that if the customer does not exist in "Sheet1" it would instead add the customer below the last customer?

Please Login or Register  to view this content.

Thanks in advance

**ragulduy** · 04-04-2014, 10:16 AM

maybe something like:

Please Login or Register  to view this content.

**kosherboy** · 04-04-2014, 10:23 AM

It worked!
Thanks.

**GC Excel** · 04-04-2014, 10:36 AM

Other suggestion :

Please Login or Register  to view this content.

**kosherboy** · 04-04-2014, 10:39 AM

Thank you. I see that your code got inserted below the last customer name.

Thanks

Insert argument in code

LinkBack

Thread Tools

Rate This Thread

Display

Insert argument in code

Re: Insert argument in code

Re: Insert argument in code

Re: Insert argument in code

Re: Insert argument in code

Thread Information

Users Browsing this Thread

Similar Threads

Argument not optional error is occurring in goal seek automated code.

[SOLVED] split the code while argument is not affected

[SOLVED] ByRef argument type mismatch / Passing array as a function argument

Compile error As "Wrong number of argument or argument or invalid Property assignment

[SOLVED] Function (array argument, range argument, string argument) vba

Bookmarks

Bookmarks

Posting Permissions