Search:

MS Office Answers

Ask Question UnAnswered

Home » Forum » MS Office

RSS Feeds

Question Asked By: Meenachi Suppiah on Feb 02 In MS Office Category.

vba routine for eliminating rows with all zeros from spreadsheet

Question Answered By: Willard Washington on Feb 02

You'll also need to stop the row increment, otherwise you bypass any
zero rows that are consecutive.

code ...
While (lastrow <> 0)
If /condition/ Then
code ...
i=i-1
End If
i=i+1
code ...
Wend

This Question has 6 more answer(s). View Complete Question Thread

Didn't find what you were looking for? Find more on vba routine for eliminating rows with all zeros from spreadsheet Or get search suggestion and latest updates.

Related Topics:

Tagged:vba routine for eliminating rows with all zeros from spreadsheet

RSS Feeds:	Articles \| Forum \| New Users \| Activities \| Interview FAQ \| Poll \| Hotlinks
Social Networking:	Hall of Fame \| Facebook \| Twitter \| LinkedIn
Terms:	Terms of Use \| Privacy Policy \| Contact us