Target.Address is a merged cell

[JustinT]

Hi,

I am struggling with the VBA code below. The code works fine until I delete the contents of the target cell, this does not have the desired effect of hiding the row below. I believe this is due to the target cell B315 being merged with B316. Any ideas how I can rectify this? Thanks, Justin

PS I'm a complete novice of VBA


If Target.Address = "$B$315" Then
If Target.Value = "Free text (enter text below)" Then
Range("a316").EntireRow.Hidden = False
Else
Range("a316").EntireRow.Hidden = True
End If
End If

 

[Joe4]

Welcome to the Board!

It is a known fact that merged cells wreak all kinds of havoc with things like sorting and VBA. They cause much more problems than they solve, and it is highly recommend that you avoid using them, if at all possible. Most serious programmers avoid using them at all costs.

If you were merging across single rows, there is a "Center Across Selection" formatting option that gives you the same visual effect, without all the issues (see here: https://www.atlaspm.com/toms-tutori...er-across-selection-instead-of-merging-cells/). Unfortunately, there really isn't a good alternative for replacing merged rows within a single column. Depending on why the reason for the merged cells in the first place, I might try to consider something like increasing the row height.