Forum Discussion

Copper Contributor

Dec 12, 2024

I need a little help

I've played around with the code and I still can not get it to execute the command. Here is the code in question. If [C2] = "Initial Legal Filing" And [C34] = "Two Defendants-Served at Differ...

Formulas and Functions

Macros and VBA

m_tarler

Bronze Contributor

Dec 13, 2024

I would make sure the values are correct. I would use debug and step through and the immediate pane (ctrl-g) to test each component. for example

print [C34]="Two Defendants-Served at Different Addresses"

and see if it returns TRUE

and also in the immediate pane you can

Sheets('Sheriff's Svc-Addtl Address").Visible = False

and see if that works