VBA to format row 2 and last column

I am trying this vba code that is not working =_=

I am changing the format of row 2 and the last column

Please Login or Register  to view this content.

This gives me a compile error on the bolded part above (.columns)

Originally Posted by Richard Buttrey

Hi,

Remove the . before the Columns.Count.

Incidentally it's not good practice to use the sheet tab name in VBA code. The tab name is too easily changed and a procedure that relies on it will crash.
Instead use the VBA sheet code name.

e.g.

Please Login or Register  to view this content.

I feel like a foo.... thanks Richard!

your point on sheet tab in VBA is noted!

Thanks again bro