first enty colomn VBA loop

[Sayf1]

Hi all,

i created a loop but I have MYCOLOMNas a variable representing where the macro should start. So 1=A B=2 and so on. I was wondering how I change my colomn to start from the first empty colomn and run the macro from there



thank you!

 

[Nine Zero]

yeah try this out this assumes you have data in row 1

Dim lastCol as Long
lastCol = sht.Cells(1, sht.Columns.Count).End(xlToLeft).Column + 1

 

[Nine Zero]

yeah try this out this assumes you have data in row 1

Dim lastCol as Long
[COLOR=#00007F]Set[/COLOR] sht = ThisWorkbook.Worksheets("Sheet1")
lastCol = sht.Cells(1, sht.Columns.Count).End(xlToLeft).Column + 1

inserted a line i forgot