0

The output data I get has certain columns that are off by a factor of 10. There are about 50 columns, and in each batch of data the same columns are always off by 10. When I try to run I get an type mismatch" error. Here is the code I have so far:

Sub FixData()
Dim finalRow As Long
Dim rng As Range
Dim cell As Range

finalRow = Range("A100000").End(xlUp).Row

 Set rng = Range("F1:F" & finalRow)
 
 For Each cell In rng
 cell.Value = cell.Value / 10
 Next cell
 
 
  
    
End Sub
abigidiot
  • 11
  • 2

0 Answers0