Excel/VBA

F

FR

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
 
B

Bob Phillips

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)
 
C

CLR

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
 
Top