Hi all!

I have a question regarding programming in VBA excel 2010. I am a rookie in programming so I could really use some help.

My problem is keeping the formatting while selecting a cell in a range, ex. S2:S100, to a new cell C7. I was able to copy(and paste...) the value, but I can't find a good solution on how to keep the formatting.
Any suggestions on how to solve this problem?

Best regards,
Matilda