Hi Macro Pod,

Thanks for your response. however I need the macro to run seemlessly without any user input. Is there a way to bpypass the VB prompt and not having to manually select the numbers and just force the currency format to column 2 > row 2 and below?

All the items in Column 2 are prices of items (except the header of course) and then they get added all together for a price total using another macro.