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.
Additional Info:
The error says:
Run-time error '1004':
Application-defined or object-defined error