VBA Problem error 91 - Azure Virtual Desktop

Question

We use our excel reports in our virtual desktop. Now we are testing with our reports in Azure Virtual Desktop and there's a excel report coming out of a error:

Cells.Find(What:="zzz", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
        xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
        , SearchFormat:=False).Activate

I don't have much experience with this so i don't see what i have to change. I need some help :) Thank you in advance.

Whats the error? `VBA Problem error 91`, anything more to go off? — Jeremy Thompson, Nov 24 '22 at 08:00
The yellow arrow puts out on the last line. It's about subtotals. This report is working in another virtual desktop. The error is only within Azure Virtual Desktop. — Luc van Iersel, Nov 24 '22 at 08:18
Double check its supported Google: KB257757 - first article. — Jeremy Thompson, Nov 24 '22 at 08:20
Thank you. Some reports do work. Is that weird or can this be a problem for just a report. — Luc van Iersel, Nov 24 '22 at 08:29
Try and reproduce it on a few other machines and if its specific to Azure Virtual Desktops you may need to raise a support case with Microsoft. — Jeremy Thompson, Nov 24 '22 at 08:31
@LucvanIersel Are you sure that the string is present in your search area (see also https://stackoverflow.com/a/29879628/17172829) — Shrotter, Nov 24 '22 at 08:51

score 0 · Answer 1 · answered Nov 25 '22 at 05:35

You should activate cell only after successful search.

Set result = Cells.Find(What:="zzz", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
    xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
    , SearchFormat:=False)
If result is Nothing Then
    MsgBox "Nothing found"
Else
    result.Activate
End If

VBA Problem error 91 - Azure Virtual Desktop

1 Answers1