Using If statement to check cell contents.
Closed
Tiny
-
May 25, 2010 at 09:54 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 25, 2010 at 04:19 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 25, 2010 at 04:19 PM
Related:
- Using If statement to check cell contents.
- Fenix internet on bank statement - Guide
- Check soft - Download - Finance
- An if statement nested within another if statement will produce how many possible results? - Guide
- How to check if someone is spying on my whatsapp - Guide
- How to check pc power consumption in windows 11 - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 25, 2010 at 04:19 PM
May 25, 2010 at 04:19 PM
Not sure what you are asking.
'If ((ActiveCell.FormulaR1C1 = "=LEFT(RC1,11)") = FindString) _
this part is saying if the formula in the active cell is Left(An, 11) = find string, where n is the row number. If you had meant to compare the left 11 characters of the cell with find string then you need to call as
If (LEFT(ActiveCell, 11) = FindString)
SInce you are saying you are learnign VB, may be it would help if you post more snippet of your code. Or post book at some shared site like https://authentification.site , http://wikisend.com/ , http://www.editgrid.com etc and post back here the link
'If ((ActiveCell.FormulaR1C1 = "=LEFT(RC1,11)") = FindString) _
this part is saying if the formula in the active cell is Left(An, 11) = find string, where n is the row number. If you had meant to compare the left 11 characters of the cell with find string then you need to call as
If (LEFT(ActiveCell, 11) = FindString)
SInce you are saying you are learnign VB, may be it would help if you post more snippet of your code. Or post book at some shared site like https://authentification.site , http://wikisend.com/ , http://www.editgrid.com etc and post back here the link