Hide Rows containing formulas but No Data Empty Text

[ria.arora]

I am exporting data from Access to excel, once all the data is exported into multiple sheets. I have one Master Sheet which has formula / reference to other sheets. I want to hide those rows which do not have
data but contain formulaes referencing back to another sheet.

How to hide those records has formula but do not have data.

Thanks
Ria

 

[ria.arora]

I need to hide these records using MS Access 2007 VBA

 

[ria.arora]

Any solution?

 

[Pat Hartman]

When I need to figure out how to do something in Excel with VBA, I open Excel and start the macro recorder while I complete the function manually. The VBA generated by the macro recorder can be used (with some tweaking) in Access.

 

[ria.arora]

I could not find any function in Excel as well to hide the rows dynamically if there is no value.

 

[Brianwarnock]

Only cells have values, not rows or columns. You would need to check each cell in the row that might have data and then if none had hide the row, but remember that as the data is being generated by formulae you must check for the "no data" value as per the formula probably "" or " "

Brian

 

[Pat Hartman]

This isn't really an Access problem. It is an Excel problem. Try asking for help in an Excel forum. We can help tweak the code so it works from Access.