Forum Discussion
Solved
Debug Error on Macro
Does any know why I get Debugged in the following macro. I copied the syntax directly from a video tutorial and have double checked that it appears correct. The the first debug (yellow highlight) ap...
ROUNDDOWN is a built-in function. The use of it is
=ROUNDDOWN(number, num_of_digit)
The macro you wrote is a procedure to repeatedly insert function/formula into the cell in column U. So, it is not related to whether macro recognize ROUNDDOWN
You may try to change the num_of_digit parameter to see if it works. I thought ROUNDDOWN(A1,0) will gives a value round down to the nearest integer.
Personally , since the cells seem to be contiguous as a starter I would use a single expression:
Range("AZ30:$AZ99").Formula = [Here use the first formula at the top]
This expression will automatically copy the formula in each cell as relative formulas.
Please look at the double quotation marks at the end. As in ..... $U99=$S99,"")"
Are you sure they're ok?
While I'm looking at the formula, since they are all copied down in column AZ, you do not need to $ in the reference.
Daniel
Range("AZ30:$AZ99").Formula = [Here use the first formula at the top]
This expression will automatically copy the formula in each cell as relative formulas.
Please look at the double quotation marks at the end. As in ..... $U99=$S99,"")"
Are you sure they're ok?
While I'm looking at the formula, since they are all copied down in column AZ, you do not need to $ in the reference.
Daniel