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.