Need help sorting macro that's causing an error

[tfilipe]

Hi all,

I've been trying to created a workbook to store contact information! "File attached"

I have 3 sheets, well 2 sheets really that related to this error, a database sheet and an interface where I can load contact information, when running the macro to update a contact, it generates an error on another macro that refreshes the database! Not sure I am explaining myself well, bellow is the code that generates the error, line 6 .Range("D28:O".............

Hope someone can assist me with this as I am out of ideas why this error happens! and also it seems to be causing the contact data to shift one row to the right on the contact database

Please Login or Register  to view this content.

[AlphaFrog]

That line of code isn't causing the data to shift, it is erroring there as a result of the data shifting earlier in it code. It errors on that line because the start date in J2 is no longer a date. So it can't copy that cell value.

I don't know where that data shift actually occurs. I'm guessing you either don't have your "data map" set up correctly in column AB on the interface sheet, or you don't implement the data map correctly in the code.

[tfilipe]

Thanks for your comment Alpha, got it fixed!