-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
contained value
-
S
VBA Clear Cell if
Hello, I'm new to VBA and need some help. Im bascially trying to say - look in column C, if the value is "State ID" then clear contents <tbody> Sub ClearRowWith_ID() Last = Cells(Rows.Count, "C").End(xlUp).Row For i = Last To 1 Step -1 If (Cells(i, "C").Value) = "State ID"...- Sparda142
- Thread
- clear contents contained value state vba vba & excel
- Replies: 2
- Forum: Excel Questions
-
H
Vba code or formula to search value in column and return the same
Hi Mr.Excel, I am looking for vba code or formula where I can search number in the given column (this column combination of numbers, text and special characters). In this I would like to take only number which I require or entire cell which contain the requested number, if provided number does...- harinsh
- Thread
- contained contained value data search string address
- Replies: 8
- Forum: Excel Questions
-
S
How to automatically identify contained values within text- VBA
Hi, I am working with the following code in order to identify if the selected values are present in "Column B" of other worksheets within the same file. The issue I am trying to solve now is that it just colours the cells with the SAME value but it does not identify those with the contained...- sm3117
- Thread
- contained value macro - help value within value within a string vba help
- Replies: 2
- Forum: Excel Questions
