Have error in Save macro - HELP!!

[Learning ExL]

hi all,

i have this Save macro which im using with data mapping

Please Login or Register  to view this content.

and when ever i run the macro i get an error on the following line

Please Login or Register  to view this content.

the

Please Login or Register  to view this content.

is supposed to be when the cell row is supposed to start which in this case is row 11, which is correct.

i just cant understand why, i was sure i did everything right....obviously not!!!!

[nigelog]

Is it not

Please Login or Register  to view this content.

or have I totally misunderstood

[adhawan06]

Just remove Range object from the following line

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

Let me know if this works.

[Learning ExL]

no because its look for the Range starting in C11

this is where im getting all this from

https://www.youtube.com/watch?v=SnA3cct-2IM&t=3616s

[Learning ExL]

im also having issues with the delete macro as well but ill probably need to start a new thread for that one

[adhawan06]

no because its look for the Range starting in C11

this is where im getting all this from

https://www.youtube.com/watch?v=SnA3cct-2IM&t=3616s

Have you tried the solution provided by me?

Removing Range Object from your bug line

Please Login or Register  to view this content.

[nigelog]

What are you trying to do? Add the new contact info from row 6 to the next available row? ie 23 of to insert row 6 at row 11?

[Learning ExL]

this code looks at the range and insert the new contact into the next available empty row at the end of the range.

did you look at the workbook and the video at all?

[adhawan06]

Hi Learning ExL,

Can you be more specific about your requirement? As asked by @Nigelog already. As per your code, the record you have on 11th row, is going to be repeated in the next available row everytime you run the code.

[Learning ExL]

ive answered the question i have explained what i need and what is wrong, ive also provided the file and the link to the video, putting all that together explains 100% of what im trying to achieve, i dont know what else to say or do.

[nigelog]

Well I hope you find your solution

[Learning ExL]

sorted it all working

[nigelog]

No Problem, glad to help