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

No idea what you are doing, but assuming that SrcRow and DsrRow are range
variables, perhaps

ActiveSheet.Rows(SrcRow).Cut
ActiveSheet.Rows(DsrRow).Paste


--

HTH

RP
(remove nothere from the email address if mailing direct)


"FR" wrote in message
...
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

Maybe........ Data Filter AutoFilter, then select the value of interest
in the column of interest and filter..........then delete those rows

Vaya con Dios,
Chuck, CABGx3



"FR" wrote:

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