Excel 2007 : Macro uses the same number of cells when proper case

I am trying to make macro for proper case the text in column A but the problem is that the macro uses the same number of cells i used to record the macro. For example, if i record the macro with 10 cells that have text in column A after this if i put a different text in 40 cells in column A and run the macro it will proper case only the first 10 cells with text. How to fix this? I want to make macro that will proper case all the cells from column A no matter if every time there is a different number of cells with text.


Thanks!