I am using VBA to do some clean up to a work sheet after users enter some data.
Every sheet is going to have only one instance of the following cell combination:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Some number[/TD]
[TD]T[/TD]
[/TR]
</tbody>[/TABLE]
So I want to find the value in the cell to the left of the one cell with a T in it, produce a message box bringing that value to the attention of the user if the value is not zero.
Any quick slick ideas? Tips?
Every sheet is going to have only one instance of the following cell combination:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Some number[/TD]
[TD]T[/TD]
[/TR]
</tbody>[/TABLE]
So I want to find the value in the cell to the left of the one cell with a T in it, produce a message box bringing that value to the attention of the user if the value is not zero.
Any quick slick ideas? Tips?