D
Dan
Hello -
I have the following code which is processing very slowly. Ever since
I added in the TRIM section, it has slowed way down.
FYI...the amount of active cells in column C change, so I just used a
default number of 1000, but this can be changed if needed.
Thanks for any ideas! Dan
Sub ODBC_Refresh()
' Refresh the hidden "ODBC Updates" worksheet with current data
Sheets("ODBC Updates").QueryTables(1).Refresh _
BackgroundQuery:=False
' Format UPC column into Text
Columns("C:C").NumberFormat = "@"
' Trim UPC's on ODBC Updates
Dim rng As Excel.Range
Dim cell As Excel.Range
Set rng = Sheets("ODBC Updates").Range("C2:C1000")
For Each cell In rng
cell = Trim(cell)
Next cell
End Sub
I have the following code which is processing very slowly. Ever since
I added in the TRIM section, it has slowed way down.
FYI...the amount of active cells in column C change, so I just used a
default number of 1000, but this can be changed if needed.
Thanks for any ideas! Dan
Sub ODBC_Refresh()
' Refresh the hidden "ODBC Updates" worksheet with current data
Sheets("ODBC Updates").QueryTables(1).Refresh _
BackgroundQuery:=False
' Format UPC column into Text
Columns("C:C").NumberFormat = "@"
' Trim UPC's on ODBC Updates
Dim rng As Excel.Range
Dim cell As Excel.Range
Set rng = Sheets("ODBC Updates").Range("C2:C1000")
For Each cell In rng
cell = Trim(cell)
Next cell
End Sub