ilikered100
New Member
- Joined
- May 29, 2013
- Messages
- 46
Ok... so I have a simple piece of code that works fine.
Basically it is checking the ActiveCell to see if any part of the cell contains the word "Cat" and if it does, it returns "True" in the cell one column to the right.
'Checks the activecell value to see if any part of the cell contains the text "Cat"
If ActiveCell.Value Like "*Cat*" Then
ActiveCell.Offset(0, 1).Value = "True"
End If
What I would like it to do is to check the ActiveCell to see if any part of the cell contains the word "Cat" but I would like to reference a cell that contains the word "Cat" (e.g. cell A1) instead of the actual word "Cat"
I tried something like this, but it didn't work
'Checks the activecell value to see if any part of the cell contains the text in cell A1
If ActiveCell.Value Like "*Cells(1,1)*" Then
ActiveCell.Offset(0, 1).Value = "True"
End If
Any help is appreciated.
Basically it is checking the ActiveCell to see if any part of the cell contains the word "Cat" and if it does, it returns "True" in the cell one column to the right.
'Checks the activecell value to see if any part of the cell contains the text "Cat"
If ActiveCell.Value Like "*Cat*" Then
ActiveCell.Offset(0, 1).Value = "True"
End If
What I would like it to do is to check the ActiveCell to see if any part of the cell contains the word "Cat" but I would like to reference a cell that contains the word "Cat" (e.g. cell A1) instead of the actual word "Cat"
I tried something like this, but it didn't work
'Checks the activecell value to see if any part of the cell contains the text in cell A1
If ActiveCell.Value Like "*Cells(1,1)*" Then
ActiveCell.Offset(0, 1).Value = "True"
End If
Any help is appreciated.