Hi,

I need to format individual columns in a macro, however once I stop recording and test run it the entire sheet ends up in whatever the last column I formatted was

I need the below

A:A = number (no decimal places)
B:B = number (no decimal places)
D:D = number (no decimal places)
F:F = number (no decimal places)
G:I = currency
N:N = number (no decimal places)
O:O = short date
T:T = number (no decimal places)
U:U = accounting

Thanks,
Jess