Macro to hide a particular row and particular column based on a formula

[Smeddlesboy]

I have been developing my excel macro skills in recent weeks, but still don't know how to write code in VBA,so anything unusual that can't be done by recording a macro still eludes me...

I need to write a macro that hides ONE row and ONE column from a workbook

Problem is the exact row and column that require hiding will vary from time to time depending on the results of other formulae.

I have successfully written a formula using ADDRESS and MATCH that works out which row and column need hiding, and stores the result in S6 (i.e. cell S6 currently contains the text "$D$9" indicating that the row and column that contain cell D9 are the row and column that currently require to be hidden. However on a different day, it could be E10 or F4 etc instead)

How can I write code to tell the worksheet to hide column D and row 9, whilst using the value in S6 to check which row and column to hide.

Also, to make things a tiny bit more complicated, I only need to hide these rows if cell P7 contains the value FALSE. If cell P7 is true, then I don't need to hide anything at all...


Thanks in advance. Am happy to re-explain if anything isn't clear

[watersev]

hi, please check attachment, run code "test"

[Smeddlesboy]

Perfect, thank you - and so simple too!

As a complete novice, I hadn't realised about using square brackets to specify a particular reference - now I know that I can probably put it to very good use!