Hide name range if 2 cells are blank vba

[tintin1012000]

I have defined a number of named ranges in my workbook

i need VBA code to hide range is certain cells are blank
hide RANGEA if cells A5 and B5 are empty
hide RANGEB if cells A10 and B10 are empty

etc

example of range
RANGEA is equal to ='test sheet'!$2:$11

any wizard available to help

Thanks

 

[pjmorris]

have you thought to use conditional formatting 'Use a Formula to determine which cells to format'? Set the background and font colours to match and the range will disappear.

HTH