ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Paste Values (https://www.excelbanter.com/excel-programming/281156-paste-values.html)

STEVEB

Paste Values
 
I have a spreadheet that has formulas in columns B, C & D. I would like
a Macro to paste values in the columns instead of having forumlas.
Does anyone have any ideas?

Thanks



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/


Ron de Bruin

Paste Values
 
Maybe this will help you Steve

http://www.rondebruin.nl/values.htm

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"STEVEB" wrote in message ...
I have a spreadheet that has formulas in columns B, C & D. I would like
a Macro to paste values in the columns instead of having forumlas.
Does anyone have any ideas?

Thanks



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/




STEVEB

Paste Values
 
Thanks Ron,

The information was very helpful, I appreciate it!



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/



All times are GMT +1. The time now is 06:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com