Code works in macro but not command button

Hi there
I've got the code below which works fine when I run it from a macro but when I put it behind a command button it only puts an 'A' into row N2 and no further. I wonder if anyone can explain why.

Thanks, as always, for any help anyone can provide.

datafiend

Please Login or Register  to view this content.

cannot tell by the code
are you able to post the example?

also you dont need the extra selects or the activesheet as you already selected it

Please Login or Register  to view this content.

click on go advanced

scroll down to the Manage Attachments button

pop up will show up
Click on add files then select files
select your file and press open
click on upload file and you will see attachment on bottom half o the screen
then just press done

two things were happening
your lastrow wasnt calculating properly so i replaced it with something that did

Please Login or Register  to view this content.

this takes all rows into account instead of just "C"....if you just want C for some reason i would suggest adding activesheet in

Please Login or Register  to view this content.

secondly your autofill wasnt picking up the right sheet so i added activesheet into the file

your method of finding last row was fine....just when i debugged it using the button....the sheet switching after you selected

instead of using all those activesheet, this is how i would have streamline the code

Please Login or Register  to view this content.