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