Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Column A has values such as http://google.com/news
Column B has values such as http://google.com I want to write a for loop so that for i =1 To iLastRow If Cells( i, 1 ) Like Cells( i, 2 ) Then Cells ( i, 1).Value= "Whatever" Next i This for loop doe snot work. I think the Like is no working correctly. It works fine when Cells( i, 1 ) Like "*cat*" But does not work when comparing with a cell for example If Cells( i, 1 ) Like Cells( i, 2 ) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
Generic protect/unprotect code through buttons and code? | Excel Programming | |||
stubborn Excel crash when editing code with code, one solution | Excel Programming | |||
VBA code delete code but ask for password and unlock VBA protection | Excel Programming |