H
Hydra
This code works nine times and then skips Sept, Nov, and Dec
I beleive this has something to do with merged cells, because those three
months are merged cells, however it it works on March which is also a merged
cell also merged cells.
Hydra
For MonthCounter = 1 To 12
Cells.Find(What:="$", After:=ActiveCell, LookIn:= _
xlValues, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:= _
xlNext, MatchCase:=False, SearchFormat:=False).Activate
PriceAddress(Monthcounter) = ActiveCell.Address
Next Monthcounter
I beleive this has something to do with merged cells, because those three
months are merged cells, however it it works on March which is also a merged
cell also merged cells.
Hydra
For MonthCounter = 1 To 12
Cells.Find(What:="$", After:=ActiveCell, LookIn:= _
xlValues, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:= _
xlNext, MatchCase:=False, SearchFormat:=False).Activate
PriceAddress(Monthcounter) = ActiveCell.Address
Next Monthcounter