Hey folks! Well, I am working on adding macros to a spreadsheet of data and one thing issue I ran into was with recording the COUNTIF formula. I carefully past each correct formula into each cell (ex. =COUNTIF(E2:E32,E2)), then when I run the recorded macros it changes the range to random selections for each cell. I opened the macros with step into to see if I can make sense of the code and saw that there were only two different formulas there and the rest showed that I made a paste.

All I want to do is record the COUNTIF function for that row and for the macros to replicate this action. Can you help?

Jen