Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a summary sheet which gets data from the other sheets. Cells B17 and C17
gets value of count from the different sources. I was writing a macro that when run along with another macro check the value of both the cell and shows message box accordingly. But it shows error that ===== Else without If ====== Code is given below. Sub final() Dim master As Range Dim ind As Range Set master = Range(B17) Set ind = Range(C17) If master(cell.Value) = ind(cell.Value) Then MsgBox "Sagregation is OKEY" Else: MsgBox "Please check the details again. There is an error" End If End Sub You can see that the If is already there but compiler cant see it. It seems a silly question but Can any one help please? Regards, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
If statement or lookup statement not sure | Excel Worksheet Functions | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions |