Macro problem driving me crazy

I've created a macro to format and sort an excel database. The macro selects the last cell used in each column, formats the font type and size and centers the text or numbers horizontally and vertically. I can't format one column which is dollar amounts. I want it to be in accounting format. I've run a sample macro to see what the code looks like but it doesn't work when I use it in my macro.

Do I need to redim the range of that column? Can I use the Range("Fx",Range("fxxxx").End(xlUp)).Select type of construct?

Thanks in advance