VBA Formula to Value

[Excelnoub]

Just wondering if there is a faster way to set a cell in Value and not a formula. Example I have the following:

Please Login or Register  to view this content.

I am stuck alway adding the following underneath this line of code making the full code:

Please Login or Register  to view this content.

Is there a better way to add the formula then change that formula to a value?

[Excelnoub]

Got it found this online,

Please Login or Register  to view this content.

[Winon]

Hello Excelnoub,

Yeah, that would be o.k. if you want to apply it to all the Cells within the Used Range.

Regards