debug code
 

hi,

Why does this not work?

Range("D & LastRow - 3:I & Lastrow - 3").Style = "Comma"

I want to format this range underneath a table, of which the length
varies.

Cheers,

Harold

debug code
 

mohavv,

you need to adjust your qotes:

Range("D" & LastRow - 3 & ":I" & Lastrow - 3).Style = "Comma"

that should work for you.

HTH,

Conan


"mohavv" wrote in message
...
hi,

Why does this not work?

Range("D & LastRow - 3:I & Lastrow - 3").Style = "Comma"

I want to format this range underneath a table, of which the length
varies.

Cheers,

Harold