I created a spreadsheet for ranking and screening dividend stocks, and posted it online. Got a comment back from one user that the UpdatePrices macro and the SortTable macro do not work in Excel for Mac 2011. I only run Windows so I can't replicate / troubleshoot the problem. Can any Mac users take a look and offer suggestions / fixes?

File is too big to attach. Macro code is below. Ticker symbols are in column B of my MainTable sheet (data starts in row 7). Updated prices go into column CX. The sort routine should sort the entire table in descending order by the column where the named range FinalScoreHeading resides.

You can also download the file (if desired) here.

Thanks in advance for any help....

Please Login or Register  to view this content.