convert Text to Number in multiple sheets simultaneously

CCH_MIA

New Member
Joined
Aug 23, 2015
Messages
2
Hello all!
I am trying to select multiple sheets and convert the text to number in all of them simultaneously but everytime I run the macro only the first one does it. Any feedback on this code please?

Sheets(Array("Countries_Send", "Countries_Receive", "Party_Send", "Party_Receive", _
"Info_Combined_Send", "Info_Combined_Receive")).Select
Cells.Select
Selection.UnMerge

Dim rUsedRange As Range
Sheets(Array("Countries_Send", "Countries_Receive", "Party_Send", "Party_Receive")).Select
Cells.Select
For Each rUsedRange In Intersect(ActiveSheet.UsedRange, Selection).Areas
rUsedRange.Value = rUsedRange.Value
Next rUsedRange

End Sub
 
I don't think you can do it "simultaneously", but you could loop through each sheet like this...

Code:
    [color=darkblue]Dim[/color] ws [color=darkblue]As[/color] Worksheet
    
    [color=darkblue]For[/color] [color=darkblue]Each[/color] ws [color=darkblue]In[/color] Sheets(Array("Countries_Send", "Countries_Receive", "Party_Send", "Party_Receive", _
                                "Info_Combined_Send", "Info_Combined_Receive"))
        ws.Cells.UnMerge
        ws.UsedRange.Value = ws.UsedRange.Value
    [color=darkblue]Next[/color] ws
 
Last edited:
Upvote 0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top