Excel/VBA
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
|