'A Chrome Extension is breaking my webapp... Maybe
I have two users that cannot use my webapp because of code injected (I believe) from a Chrome Extension. They are using the latest Chrome and I can see in the Sources panel where the code is injected. Any insight on this would be greatly appreciated.
The end of my script looks like this:
printBlob=css+printBlob+"";
$("#landHere").html(printBlob);
But, the code looks like this in the User's Sources panel in Chrome:
printBlob=css+printBlob+"<script type='text/javascript'src="[my web address]/608603eb04c81ed77de982550fe5271fd37489ee3cc5ba58cb390d27d64fbe2/inject.js
Thanks in advance!
Solution 1:[1]
Range.Find can get that done for you.
Sheet2.Cells.Find(What:=DropdownValue).Select
Be careful of doing it in a single line though. This will raise an error if the Find method doesn't find any matches since you can't do Select on Nothing.
It's safer to do it in separate lines like:
Dim rFind As Range
Set rFind = Sheet2.Cells.Find(What:=DropdownValue)
If Not rFind Is Nothing Then rFind.Select
And for reliability and completeness, you should include the other arguments of Find, to ensure the method is using the matching rules that you expect. The most critical ones are LookIn, LookAt and MatchCase.
Set rFind = Sheet2.Cells.Find( _
What:=DropdownValue, _
LookIn:=xlValues, _
LookAt:=xlWhole, _
MatchCase:=True _
)
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 |
