mercredi 12 juillet 2017

VBA excel, if Cells(counter,1)="text" then

I'm trying to execute an if statement that only activates if a certain cell contains a specific text. The cell in question needs to be dynamically altered based on a integer that will change, so far ive tried multiple methods but nothing seems to work.

If Cells(counter, 1).text = "text" then

If Cells(counter, 1).value = "text" then

If Range(Cells(counter, 1)).text = "text then

If Range(Cells(counter, 1)).value = "text then

This seems like a simple procedure, does someone have a solution?

Thanks, Sporre

Aucun commentaire:

Enregistrer un commentaire