Excel VBA Macro to Paste Values & Number Formatting But Not Formulas 

Great video. I was wondering if you have another video that would help hard code specific cell in multiple sheets. I am trying to hard code prior month numbers while leaving the formula for future months (keeping historical numbers). Thanks

I want to paste the value in the cell I clicked on, not cell A15, how do I code it?

Thank you very much! I have viewed and tried several different videos and this is the one that works for my project. Very well presented, easy to follow and excellent subject knowledge

How can I assign values that includes the formats like if it is bold. For example cells(1,2).value=cells(1,1).value but it must include the bold format from cells(1,1).

Presumably the second macro will not give you the number formatting unless you had already applied those by the earlier Copy and Paste Values macro.

First of all thanks a lot for this, Second I got a question: I wrote this code and it keeps giving me an error that the size of the copy area and the paste area are not the same. but if I just use the copy-paste method, it works perfectly. could you pls help me out. Sub copy() eRow = Sheet5.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row Sheet4.Range("a4", "d23").copy Sheet5.Cells(eRow, 1).PasteSpecial (xlPasteValues) End Sub

Sir kindly let me know how i paste special multiple times at constant interval of time

Thank you so much for this video...!

thank you

this was a life saviour :") THANK YOU SO MUCH

Hi, can you please explain how we can change the range to select cells A1:H1 and down to the last row (so when there are new rows of data added these aret's excluded)? Thanks :)

thanks this is very useful

Thanks ... Thanks.

Thank you, really help me