Hi,
I think this should be fairly easy, but I cant work it out.
I have my own UDF setup "=autocrit(A2)" that pulls back the autofilter criteria for the autofilters in place. In short I want to incorporate this into an easy run macro to insert a row and paste the formula into the cell above the autofilter. Thats not a problem.
The bit I am struggling with is entering the formula in every column with data and setting the reference correctly.
I.e. Column A =autocrit(A2), Column B =autocrit(B2) etc.
All help appreicated
DOMAL
I think this should be fairly easy, but I cant work it out.
I have my own UDF setup "=autocrit(A2)" that pulls back the autofilter criteria for the autofilters in place. In short I want to incorporate this into an easy run macro to insert a row and paste the formula into the cell above the autofilter. Thats not a problem.
The bit I am struggling with is entering the formula in every column with data and setting the reference correctly.
I.e. Column A =autocrit(A2), Column B =autocrit(B2) etc.
All help appreicated
DOMAL