MS Excel Macro issue
 

Hi everyone,
I am kind of new to using MSExcel and I am having a little trouble with
macros.I have to sum up few rows based on some conditions, so I used a SUMIFS
and then I have to count the rows based on some conditions again and so I
used a COUNTIFS. I recorded a macro while putting in these formulas.The
problem is, if I add more rows to the excel sheet and then run the macro, the
new rows will not be included in the computations performed by the macro. Is
there a way that this can be resolved?I've done some research on this and all
I found was that editing macros is not a good idea. Any inputs would help me
greatly. Thanks in advance.

MS Excel Macro issue
 

Hi.
For intance, you may want to use :
Range("A1", Range("A65536").End(xlUp))
to select the column A range from A1 to the last non blank cell.
Regards.
Daniel
Hi everyone,
I am kind of new to using MSExcel and I am having a little trouble with
macros.I have to sum up few rows based on some conditions, so I used a SUMIFS
and then I have to count the rows based on some conditions again and so I
used a COUNTIFS. I recorded a macro while putting in these formulas.The
problem is, if I add more rows to the excel sheet and then run the macro, the
new rows will not be included in the computations performed by the macro. Is
there a way that this can be resolved?I've done some research on this and all
I found was that editing macros is not a good idea. Any inputs would help me
greatly. Thanks in advance.

MS Excel Macro issue
 

I'm not sure who told you editing macros is not a good idea; often it is the
only way to achieve a 'robust' and adaptable solution.
Exercise caution, yes, fear to tread on new ground - no.

If you post your recorded macro, I'll bet we can get it to a 'robust and
adaptable' state.

"msofficehelp" wrote:

Hi everyone,
I am kind of new to using MSExcel and I am having a little trouble with
macros.I have to sum up few rows based on some conditions, so I used a SUMIFS
and then I have to count the rows based on some conditions again and so I
used a COUNTIFS. I recorded a macro while putting in these formulas.The
problem is, if I add more rows to the excel sheet and then run the macro, the
new rows will not be included in the computations performed by the macro. Is
there a way that this can be resolved?I've done some research on this and all
I found was that editing macros is not a good idea. Any inputs would help me
greatly. Thanks in advance.