Dynamic macro parameters
When calling an add-in function from a worksheet, is
there a way to make the parameter change when a row is
inserted or deleted? In other words, I have a function
that receives an argument that is a row number. If the
row number changes, I want my argument to automatically
change. The built-in functions do this, but I have not
been able to figure out how to make my functions do
this. If I use Row(A37) as the argument, it works great,
however, I only want to pass the row number not use a
built-in function as a filter.
|