Excel Q&A

Home

Forum

Advanced Excel Topics

Excel Q&A
- Excel Q&A

Ask your geeky hard core Excel questions here!

Questions/Discussions

Sort by Date ▼ / Top Rated

New Collection and Looping

I want to build a new collection from a desired range, but I want to skip the blank cells. I tried to begin the loop with Do While Not (ISempty(activecell)), but this is still pulling blank cells. The collection involves 2 thresholds - a minimum and maximum budget variance - corresponding to a list... Read More

Show All 1 Replies Login to Reply

by Brendan K.

added 7 years ago

Show More Show Less