I have a column with a formula/function that has other cells as parameters. However in the column, every few rows I have a subtotal and blanks, for readability. Now I decided to change the formula/function but I can not do copy+paste on the whole column because of the subtotals/blank cells, and I can not do change+replace because there are parameters in the functions that uses other cells and thus it is different in each cell in the column.
For example, if the formula is
=if(A5>24,1,"") and I want to change it to
Any idea how to change it easily? currently I copy+paste few rows at a time, but that is tedious.
Maybe a Sub that will go all over the column (the column number as an input parameter) and looks for
=if(, and then replaces it with
=aa_userfn(Ax, By) where
By are calculated based on the position of the cell currently changed in reference to the previous values in that cell.
Any ideas will be welcomed