I have the code below ,but the data has changed so I need to look for "CLEAR" in that cell that will have other data now. For example K5 would read "Light Intensity CLEAR" how do i adjust to look for CLEAR with other data now in the cell. Thanks
Set ws = Sheets("Sheet19")
Set ws_pic = Sheets("Pic")
Set cel = ws.Range("k5")
Select Case cel
Set Shp = ws_pic.Shapes("Picture 30")
Case "FEW CLOUDS"
Set Shp = ws_pic.Shapes("Picture 32")
Case "PARTLY CLOUDY"
Set Shp = ws_pic.Shapes("Picture 28")
Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat. The purpose of this eBook is to educate the reader about ransomware attacks.