Looking for a VBA to hide rows

[MHGI]

I'm creating an evaluation tool at work and would like to write in a VBA that will hide all rows where as column A# are blank. I'm pulling data from Sheet A based on an if/then formula and if the data is blank or doesnt meet the criteria, then it is a blank cell in Sheet B. Blank cells in Sheet B are the ones I want hidden without having to do it manually - cause I'm not the one going to be using the document.

Any help at all would be appreciated. - Trying to get this project completed ASAP.

[tigeravatar]

MHGI,

Welcome to the forum!
It is likely that your formula could be adjusted to skip blank cells from Sheet A. Can you post a sample workbook so that we can take a look at it? To attach a file, click the "Go Advanced" button and then click the paperclip icon to open the Manage Attachments dialog.