Hello guys,
I have a massive spreadsheet which in which the number of columns is going to change each time I run it. I want to label the column after the last column with data and put formula in it. I have searched for a solution but there are examples for dynamic row numbers only. I found this code which finds the last column in a spreadsheet but couldn't write the code which takes me to the next blank cell/column for the first row. Could you please help me with that. Thank you
Sub Last_Collumn()
Range("A1").End(xlToRight).<wbr>Select
End Sub
I have a massive spreadsheet which in which the number of columns is going to change each time I run it. I want to label the column after the last column with data and put formula in it. I have searched for a solution but there are examples for dynamic row numbers only. I found this code which finds the last column in a spreadsheet but couldn't write the code which takes me to the next blank cell/column for the first row. Could you please help me with that. Thank you
Sub Last_Collumn()
Range("A1").End(xlToRight).<wbr>Select
End Sub