Macro to select a column that varies in number of rows from report to report

Howdy from Austin,

I am running a macro on a monthly report that contains credit card Transaction Amount data. The quantity of Transaction Amount column rows vary from month to month.

I have a formula to format the text data into currency, but I want the macro to work for each monthly report regardless of how many rows.
Since every report has a different quantity of rows, how do I create a macro that determines the exact number of rows in the Transaction Amount column?

Thanks,
Mark

Thank you, Bernie.

My issue is how do I create a macro that can select the exact number of rows in a column that changes every month? It's the same column in each monthly report, but every month has a different number of records (rows).

I need to be able to know how many rows there are each time so my formatting formula stops at the last row of the column.

Hope that makes sense.

Thanks Bernie....I'll give it a try!