Macro to copy and paste sepcial into next blank row

**CharlieZangel** · 06-10-2013, 03:57 PM

I have 12 sheets of data that I would like to collate into one sheet (sheet 13), I must be over looking something because I just cant seem to get this to work. Please review my code below, it hangs at the last line, what am I missing?

Please Login or Register  to view this content.

I hope someone can help me with this.
Thanks in advance for your help

**stnkynts** · 06-10-2013, 04:09 PM

PasteSepcial should be PasteSpecial. There might be more than that wrong but its what i see from first glance.

Note: It appears as though you are going to be copying the same range across all worksheets but number 13. Here is a quick way to do that

Please Login or Register  to view this content.

**CharlieZangel** · 06-10-2013, 04:12 PM

Thanks stnkynts, Good catch, fixed that but still no luck

**stnkynts** · 06-10-2013, 04:18 PM

where is the rest of your code and what are you trying to do? See added code above to see if it does what you want.

**CharlieZangel** · 06-10-2013, 04:21 PM

Thanks, i think the issue was the paste special function I was using, I tried "xlvalues" instead of "xlPasteValuesAndNumberFormat" and it worked fine. Thanks for your help