Help Needed with Macro to Change Formulas to Text Using Ranges

rsrasc · #2 11-29-2016, 01:41 PM

I found the following code in the following link:

http://www.rondebruin.nl/win/s9/win015.htm

This code will allow me to change the formulas from cells A4 through A100 to values.

Now, that I have this, I will try to find a macro that will do it for all the tabs automatically. It only works in individual tabs. Well, at least, it's a start.

Code:

Sub Range_Example_1()
    With Range("A5:A100")
        .Cells.Copy
        .Cells.PasteSpecial xlPasteValues
        .Cells(1).Select
    End With
    Application.CutCopyMode = False
End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Take String of numbers, expand ranges, sort, then compress back into ranges	AustinBrister	Word VBA	19	08-22-2016 05:18 PM
Write a macro to change formulas	Xyz_999	Excel	2	04-20-2016 10:40 PM
Write a macro to change formulas	Xyz_999	Excel	1	04-20-2016 09:51 PM
Macro Needed To Convert Text in Word to Plain Text and Back to Word	rsrasc	Word VBA	5	12-18-2015 07:13 AM
Help needed: Table Formulas with AND	Scrapyard	Word Tables	3	01-26-2014 12:36 AM