debug code

M

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
 
C

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top