I have a few formulas like below that reference sheet "Data"
etc
my issue is my macro runs and deletes columns out of sheet "Data" and edits my code to below and completely changes my formulas.
I have tried adding the $A:$Z but that doesn't stop it either.
Any ideas?
sheet1,B1 =COUNTIF(Data!A:Z,A1)
sheet1,B2 =COUNTIF(Data!A:Z,A2)
etc
my issue is my macro runs and deletes columns out of sheet "Data" and edits my code to below and completely changes my formulas.
sheet1,B1 =COUNTIF(Data!A:[B]T[/B],A1)
I have tried adding the $A:$Z but that doesn't stop it either.
Any ideas?