disappearing values with simple code

**kamelkid2** · 05-21-2012, 10:05 AM

i had this sub created and attached it to a button within my spreadsheet

Please Login or Register  to view this content.

this worked perfectly. however i found a need that i wanted to expand upon the same button to move a similar set of data and i used this code:

Please Login or Register  to view this content.

however it does not work. the data in range e2:e7 will disappear and not paste into the n2:n7 range. i am very new to VBA and so im curious as to what may be the issue with this? is it just formatting or is there a deeper issue i am not understanding. thank you for any help.

to clarify: i want to move both sets of data with one press of a button

**tom1977** · 05-21-2012, 10:10 AM

Hi for me it works. Are You sure that the names of sheets are correct?

**kamelkid2** · 05-21-2012, 10:13 AM

hmm. i must have had a typo. i retyped everything and it worked this time. thank you for quick response

**AlvaroSiza** · 05-21-2012, 10:13 AM

Originally Posted by kamelkid2

however it does not work. the data in range e2:e7 will disappear and not paste into the n2:n7 range.

As written, you are telling excel to make your "E" range whatever your "N" range is. I think you just need to switch them around based on your explanation.