- Hot Topics
Excel Array for Multiple Sheets??
Code: Sub Macro9() Dim wsO As Worksheet Dim LR As Long Dim i As Integer Dim iws As Integer Dim myPosition As Long Application.ScreenUpdating mySheets For myColumns = Array("TransactionID", "order_id", LR = Range("A" & Rows.Count).End(xlUp).Row For Selection.NumberFormat = "0" For Each xCell In Selection xCell.Value = CDec(xCell.Value) Next xCell Next i
This question generated 25 answers. To proceed to the answers, click here.
This thread is current as of August 11, 2014.
For more resources for Microsoft Excel:
This article includes the following tags:
- Microsoft Excel