-1

I created a new macro earlier and it was working fine but now I get this error. I have not changed anything including the columns or worksheet name, any ideas why it's erroring now? The row that is highlighted in yellow when I try to debug it is:Columns("L:L").Select. 

Sub FTE_Joiners()

 FTE_Joiners Macro

Sheets("Joiners").Select
Columns("L:L").Select
Range("L2").Activate
Selection.NumberFormat = "0"".""0""""0"
End Sub
Pᴇʜ
  • 56,719
  • 10
  • 49
  • 73
Analyst1
  • 19
  • 7

1 Answers1

1

You can reduce that to 

Sheets("Joiners").Columns("L:L").NumberFormat = "0"".""0""""0"

There's nothing in what you've told us that would suggest a problem.

Read this.

SJR
  • 22,986
  • 6
  • 18
  • 26