Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro is not able to identify the value.
Hi All, I have created the below mentioned loop which return me TRUE or FALSE Value in a cell. Do Until ActiveCell.Offset(0, -11).Value = "" ActiveCell.FormulaR1C1 = "=ISERROR(VLOOKUP(RC[-12],'[" & Dname & "]Data Base'!R2C1:R20000C1,1,0))" ActiveCell.Offset(1, 0).Select Loop After that I have below mentioned code but the macro is not able to detect the cell value as true or false.(In If function) I am not able to understand what is going wrong with the coding. Do Until ActiveCell.Value = "" If ActiveCell.Value = "TRUE" Then 'Here I have my code. End if Loop Heera |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro is not able to identify the value.
Use TEXT instead of value. You also looping on the same cell which will
produce an endless loop. Do Until ActiveCell.Value = "" If ActiveCell.Text = "TRUE" Then 'Here I have my code. End if Loop "Heera" wrote: Hi All, I have created the below mentioned loop which return me TRUE or FALSE Value in a cell. Do Until ActiveCell.Offset(0, -11).Value = "" ActiveCell.FormulaR1C1 = "=ISERROR(VLOOKUP(RC[-12],'[" & Dname & "]Data Base'!R2C1:R20000C1,1,0))" ActiveCell.Offset(1, 0).Select Loop After that I have below mentioned code but the macro is not able to detect the cell value as true or false.(In If function) I am not able to understand what is going wrong with the coding. Do Until ActiveCell.Value = "" If ActiveCell.Value = "TRUE" Then 'Here I have my code. End if Loop Heera |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro is not able to identify the value.
"TRUE" with quote marks is a string of characters that just *looks* like
TRUE, but it is not the value TRUE. Just remove the quote marks in your test... If ActiveCell.Value = True Then -- Rick (MVP - Excel) "Heera" wrote in message ... Hi All, I have created the below mentioned loop which return me TRUE or FALSE Value in a cell. Do Until ActiveCell.Offset(0, -11).Value = "" ActiveCell.FormulaR1C1 = "=ISERROR(VLOOKUP(RC[-12],'[" & Dname & "]Data Base'!R2C1:R20000C1,1,0))" ActiveCell.Offset(1, 0).Select Loop After that I have below mentioned code but the macro is not able to detect the cell value as true or false.(In If function) I am not able to understand what is going wrong with the coding. Do Until ActiveCell.Value = "" If ActiveCell.Value = "TRUE" Then 'Here I have my code. End if Loop Heera |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro is not able to identify the value.
Thank you Rick and Joel
Both of your's codes worked fine. Regards Heera |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro to identify columns to hide | Excel Programming | |||
how to identify the control that ran a macro? | Excel Programming | |||
Macro to identify bad dates | Excel Programming | |||
Macro to identify year within a date | Excel Programming | |||
How do you identify if a worksheet is in the last position in a Macro? | Excel Programming |