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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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