Hi,
What procedure will I use with object as worksheet so that when I select the word "TOTAL (OBS)", The code below will work?
If Sheets("CHIT1&2").Range("J12").Value = 2 Then
Set ht = Sheets("Tank 2")
u = ht.Range("A" & Rows.Count).End(xlUp).Row + 1
ht.Range("A" &...