check if there is 13 columns if not add one

[Ynss]

clients sent me a sheet that have a table from Week 1 to week 13 (13 column) some clients doesnt, for exemple just for 12, 11 weeks
i want a macro to check if there is 13 column if not add new column in specific place
any idea ?

 

[Peter_SSs]

Bit of a guess without seeing your code or what else might be on the worksheet but perhaps this might head you in the right direction?

If ActiveSheet.UsedRange.Columns.Count <> 13 Then
  'Add the column(s) in your specific place
End If

 

[Ynss]

Thank you work great,
for the emplacement where i will add the column, it's dynamic, for example, if one client sends me a table with 12 weeks the headers will be, 1,2,3....12 in this case the new column will be added in the last , but another client send me a table like 1,2,4....13 so the new column should be added in the third place
any idea how to make this solution, and thank you