Object required error

[CanadianGSX]

Mornin',

Here's the code:

Please Login or Register  to view this content.

I get an "object required" error on the nextCell = currentCell.Offset(1, 0) line. WHat I'm trying to achieve is rather simple.

Columns A, B and C

A = title
B = description
C = quantity

Delete all 0 quantity rows.

Seems like the code should work.....a little stumped.

Thanks again!

- Lou

[romperstomper]

You need Set with objects:

Please Login or Register  to view this content.

[CanadianGSX]

I get the same error but on the IF statement now

Please Login or Register  to view this content.

I had tried with Set as well....I had also tried setting the currentCell as Range to no avail...I get the same error.

Thanks for the quick reply though!

[romperstomper]

Sorry - cocked up my pasting. That should have read:

Please Login or Register  to view this content.

[CanadianGSX]

Now it deletes the ActiveCell line no matter where the active cell is ONCE and gives the same error at the IF statement....going for lunch...need to clear my head.

Thanks again for the help thus far!

[CanadianGSX]

Here's an updated code that returns the Type Mismatch error at the ' Set currentCell = ActiveCell.Address ' line:

For the life of me I can't seem to put my finger on the issue...

Thanks yet again!

-Lou

Please Login or Register  to view this content.

[romperstomper]

You don't want the .Address bit. Try:

Please Login or Register  to view this content.

[CanadianGSX]

Perfect...thanks!

Here's the final code that works like a charm:

Please Login or Register  to view this content.