Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
I'm getting a "runtime error 13 - type mismatch" error when running a macro in a spreadsheet on the company network (accessed via Citrix) at the company I work for. The line causing the error is identified below: Range("L1").Select Do Until ActiveCell.Value = "" If ActiveCell.Value = 0 Then <<--- this line Selection.EntireRow.Delete Else ActiveCell.Offset(1, 0).Select End If Loop There is more code than this, so can supply that if required. Citrix may be the cause of the problem because the exact same code works fine when I open the spreadsheet on my desktop pc (using Excel 2000). Could someone please explain to me what the problem could be, and how it could be fixed? Thanks and regards Kevin Maher |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
xpath error? Runtime Error 13 type mismatch | Excel Discussion (Misc queries) | |||
xpath error? Runtime Error 13 type mismatch | Excel Discussion (Misc queries) | |||
VB error, runtime error 13 (type mismatch) | Excel Programming | |||
Runtime Error 13 - type mismatch | Excel Discussion (Misc queries) | |||
Runtime error 13 type mismatch ? | Excel Programming |