Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a workbook "Optvol" having the word "put" in cell A10. In a macro:
If Workbooks("optvol.xlsx").Sheets("optvol").Range("A 10") = "put" Then Range("c4") = "it works" End If C4 is in the active workbook, different from "Optvol". Nothing happens upon execution, and there is no error message Clearly, for some reason the contents of Optvol A10 are not recognized. Any idea what I'm doing wrong? Appreciate all help, thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using IF Function to Recognize Highlighted Cell | Excel Worksheet Functions | |||
Recognize currency in a cell | Excel Programming | |||
Recognize first emtpy Cell in column | Excel Programming | |||
How do I make a cell's contents equal to another cell's contents with macro program? | Excel Programming | |||
recognize the cell | Excel Discussion (Misc queries) |