I have this simple formula in Cell A1
=10*Round(B1/10,0)
I know how to enter this in VBA, i simply write:
Range("A1").Formula = "=10*Round(B1/10,0)"
Now, what if I don't know the cell whose number I want to round? In other words, I have an integer variable in my code, N, that can take on multiple values, and I want to round the number in row number N of column B.
How do I write this?
I tried:
Range("A1").Formula = "=10*Round(B" & N & " & "/10",0)"
But this doesn't work. Tried multiple layouts for the quotes but without success.
Can anyone let me know:
You're rounding to the nearest 10? Equivalent formula is
=ROUND(B1,-1)
Range("A1").Formula = "=10*Round(B" & N & "/10,0)"
Here's a short post from Daily Dose of Excel: Worksheet Formulas in VBA Part I
I'd turn on the macro recorder, create some formulas, see what you get, and then google specific issues. Finally, a good book, such as one of John Walkenbach's "Power Programming in VBA" titles should help.