When I send a range to email with my macro I want it to be like a picture. I know I can copy special and paste as picture but that messes up the macro. Is there a way to lock the cells a certain way so they dont adjust when pasted? Thanks