View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Derek[_6_] Derek[_6_] is offline
external usenet poster
 
Posts: 15
Default 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.