Small Excel Question Not Worth Its Own Thread

Register a SA Forums Account here!
JOINING THE SA FORUMS WILL REMOVE THIS BIG AD, THE ANNOYING UNDERLINED ADS, AND STUPID INTERSTITIAL ADS!!!

You can: log in, read the tech support FAQ, or request your lost password. This dumb message (and those ads) will appear on every screen until you register! Get rid of this crap by registering your own SA Forums Account and joining roughly 150,000 Goons, for the one-time price of $9.95! We charge money because it costs us money per month for bills, and since we don't believe in showing ads to our users, we try to make the money back through forum registrations.

The Something Awful Forums > Discussion > Serious Hardware/Software Crap > The Cavern of COBOL > Small Excel Question Not Worth Its Own Thread

Jagershot: Jun 7, 2004; RIP Mike V, 1989-2007. Have fun mounting Bear Bryant up in heaven.

I need an Excel macro that will search for values in a cell range (D6:AZ600, for example) on each page of workbook and delete them if they are equal to zero. I suck at VBA, though. Does anyone know how to do this?

Click here for the full 670x506 image.

This is a screenshot. I highlighted the zero values in yellow. There are about 20 tabs in this workbook that I need to delete the zeros from so that I can analyze the data.

# ¿ May 12, 2010 17:36

Adbot: ADBOT LOVES YOU

# ¿ May 6, 2024 08:54

Jagershot: Jun 7, 2004; RIP Mike V, 1989-2007. Have fun mounting Bear Bryant up in heaven.

ZerodotJander posted:

Find and replace 0 with nothing, make sure you check off the "match entire cell contents" box.

Wow, that's so simple I feel completely stupid for not thinking of it. I literally spent two hours at work deleting zeros a month ago.

Thanks a ton!

# ¿ May 12, 2010 18:21

The Something Awful Forums > Discussion > Serious Hardware/Software Crap > The Cavern of COBOL > Small Excel Question Not Worth Its Own Thread