F
Fred Holmes
Is there an event that is triggered by changing the data in a
worksheet cell? What is it called?
I have a table that is filled in line by line (row by row). I want
the rows that have not yet been filled in with data to appear
completely blank all the way across. Several columns on the right
contain formulae that process the data entered into the left-hand
columns. I want the process of entering data into one of the
left-hand columns to trigger a macro that writes in the forumulae in
the right-hand columns. Trigger on a single cell, notheing more
complicated than that. Does such a trigger exist?
Right now I'm using an IF(ISBLANK(B13),"",[the real formula]) sort of
formula to accomplish this, but this makes the underlying calculation
of the real formula sort of "inscrutable" which I want to avoid.
The process of using cell formatting to make zero values appear blank
doesn't work because two of the columns are running subtotals and
totals that are not zero, even if the current line contains no data
yet.
Thanks for any help,
Fred Holmes
worksheet cell? What is it called?
I have a table that is filled in line by line (row by row). I want
the rows that have not yet been filled in with data to appear
completely blank all the way across. Several columns on the right
contain formulae that process the data entered into the left-hand
columns. I want the process of entering data into one of the
left-hand columns to trigger a macro that writes in the forumulae in
the right-hand columns. Trigger on a single cell, notheing more
complicated than that. Does such a trigger exist?
Right now I'm using an IF(ISBLANK(B13),"",[the real formula]) sort of
formula to accomplish this, but this makes the underlying calculation
of the real formula sort of "inscrutable" which I want to avoid.
The process of using cell formatting to make zero values appear blank
doesn't work because two of the columns are running subtotals and
totals that are not zero, even if the current line contains no data
yet.
Thanks for any help,
Fred Holmes