Help!!! Excel/VBA
The need: To collapse a spreadsheet by deleting irrelevant rows conditioned
on a cell in the row.
Question 1: Is there an intrinsic way of doing this built into Excel?
Question 2: I am trying to do it with VBA by cutting and pasting rows as
follows :
ActiveSheet.Rows("(SrcRow)").Cut
ActiveSheet.Rows("(DsrRow)").Paste
I keep getting €œType mismatch error€� messages. I tried other variations but
I get the impression that €œCut€� and €œPaste€� and €œRows€� and €œRange€� only
accept constants to designate a range, not variables.

What am I doing wrong?

Thanks, Robert Hollo