<integer variable> = Sheets("<worksheet’s name>").Cells(1, Sheets("<worksheet’s name>").Columns.Count).End(xlToLeft).Column
Advertisements
<integer variable> = Sheets("<worksheet’s name>").Cells(1, Sheets("<worksheet’s name>").Columns.Count).End(xlToLeft).Column