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

This video demonstrates two methods for creating a VBA macro that will only paste values including number formatting. This tutorial will be useful to you where you need to create a copy of data that does not include formulas, just the formula results.
------------------------

[@user-dx7ow1nv7y]

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

[@xx-lb7ps]

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

[@herur.m7066]

Thank you, really help me

[@sudarshanjadhav1676]

Thank you so much for this video...!

[@miteshpatel2799]

thanks this is very useful

[@MohAboAbdo]

Thanks ... Thanks.

[@noahnavarro8556]

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

[@victormoreno803]

thank you

[@AlexA-dn2bn]

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 :)

[@stuartbrown5344]

Hi, create a Dynamic List and use the name that you have assigned to you Dynamic List as the Range.

[@arielzabatecuizon5147]

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).

[@brigadeshivu]

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

[@andiandrianto3623]

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

[@payamtaheri9450]

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

[@RapThesis2326]

Because u have merged cell, it won't work in merged cell

[@clairejsquibb]

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.