Most valuable professional
  • 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:

  • Excel
  • Microsoft Excel