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

Excel/VBA
 

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

Excel/VBA
 

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