I am working on a coding for rounding decimal place (for two decimals place), the code that I did works well, but it on a specify range of cells, I want do the coding works for a range of cells in a column that could change, now I have in the column where I want to do rounding of 2 decimal place from cell I2 thru cell I2986, but if I have more or less the coding does not work:
I did the following:
Sub Rounding_TwoDecimals ()
Dim cell As Range
For Each cell In Range("I2:I2986")
cell.value = worksheetFunction.Round(cell.value, 2)
I have tried with Dim lastrow As Long, also Dim rowEnd as Long, and I cannot to find the right coding, Can anyone tell me what I need to add to this code?
Thanks in advance.