debug code

[mohavv]

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

 

[Conan Kelly]

mohavv,

you need to adjust your qotes:

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

that should work for you.

HTH,

Conan