Help with column

  • Thread starter Thread starter lennymos123
  • Start date Start date
L

lennymos123

I have a datafeed that comes to me everyday i need to format one column

of around 1000 rows so it multiples the total column but a 1000 so
getting rid of the decimal point i.e £100.00 becoming 10000 , i also

need to do this using a macro. can anyone help


Regards

Paul
 
Dim iLastRow As Long
Dim i As Long

iLastRow = Cells(Rows.Count, "A").End(xlUp).Row
For i = 1 To iLastRow
Cells(i, "A").Value = Cells(i, "A").Value * 100
Next i

--
HTH

Bob Phillips

I have a datafeed that comes to me everyday i need to format one column

of around 1000 rows so it multiples the total column but a 1000 so
getting rid of the decimal point i.e £100.00 becoming 10000 , i also

need to do this using a macro. can anyone help


Regards

Paul
 
Back
Top