Run-time error (13) Type mismatch

[solti]

Hello,The following code generates a Run-time error (13) Type mismatch:

[/FONT][/COLOR]
[COLOR=#006600][FONT=Courier]Dim IloscWierszy As Long [/FONT][/COLOR]
[COLOR=#006600][FONT=Courier]IloscWierszy = Application.VLookup(.Cells(i, 2).Value, _ [/FONT][/COLOR]
[COLOR=#006600][FONT=Courier]"'[" & PlikBudżet.Name & "]" & PlikBudżet_arkusz.Name & "'!R" & WierszKosztyPensji_Budzet + 2 _ [/FONT][/COLOR]
[COLOR=#006600][FONT=Courier]& "C" & OstKol_Budzet & ":R" & WierszKosztyPracowni_Budzet - 2 & "C" & OstKol_Budzet + 1, 2, 0)
[/FONT][/COLOR]

I checked in Immediate window with Debug.? and got "Compile error:Invalid watch expression". Result of these procedure shoul be long (number 10).
What am I doing wrong?


****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">I checked Debug.? in Immediate window and gives me "Compile error:Invalid watch expression.</body>

 

[Rick Rothstein]

Hello,The following code generates a Run-time error (13) Type mismatch:

[/FONT][/COLOR]
[COLOR=#006600][FONT=Courier]Dim IloscWierszy As Long [/FONT][/COLOR]
[COLOR=#006600][FONT=Courier]IloscWierszy = Application.VLookup([B][COLOR="#FF0000"][SIZE=3].Cells[/SIZE][/COLOR][/B](i, 2).Value, _ [/FONT][/COLOR]
[COLOR=#006600][FONT=Courier]"'[" & PlikBudżet.Name & "]" & PlikBudżet_arkusz.Name & "'!R" & WierszKosztyPensji_Budzet + 2 _ [/FONT][/COLOR]
[COLOR=#006600][FONT=Courier]& "C" & OstKol_Budzet & ":R" & WierszKosztyPracowni_Budzet - 2 & "C" & OstKol_Budzet + 1, 2, 0)
[/FONT][/COLOR]

I checked in Immediate window with Debug.? and got "Compile error:Invalid watch expression". Result of these procedure shoul be long (number 10).
What am I doing wrong?

One obvious problem is the dot you have in front of the keyword "Cells" which I have outlined in red above... there is no With statement for that dot to reference so I am thinking you should just remove it.

 

[solti]

unfortunately. Nothing changes.
Procedure is part of

with ArkuszStart

<code>

end with