Sub MostActiveDayPrediction() Dim r As Integer Dim rng As Excel.Range Sheets("Stats").Activate r = 1 Set rng = Sheets("Yahoo_Download_2").Range("Results_OEX") Do While rng.Offset(r, 0) <> "" If rng.Offset(r, 0) = Sheets("Stats").Range("Last_Monday") Then Stop r = r + 1 Loop End Sub
|Generating a graph via Excel||3||22|
|macro for each dropdown||15||44|
|Sum iF based on a null cell||11||29|
|Excel "2016 error could not load some objects becuase they are not available on this machine.||7||12|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
8 Experts available now in Live!