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")
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…