Hello Guys,
I need to find the Last Column of a specific Row -> Move to Next Row -> Add "X" in that specific cell.
Example: In Below Screen shot, Where in Row A9 -> Need to find last Column (J9) -> Insert "X" in Next row (K9).
Note: We cant simply specify the Cell Number and enter the data since each time cell will be changing.
i tried below formula but still unable to get what i need.
LC = ActiveSheet.Cells.Find("*", SearchOrder:=xlByColumns, SearchDirection:=xlPrevious).Column
I need to find the Last Column of a specific Row -> Move to Next Row -> Add "X" in that specific cell.
Example: In Below Screen shot, Where in Row A9 -> Need to find last Column (J9) -> Insert "X" in Next row (K9).
Note: We cant simply specify the Cell Number and enter the data since each time cell will be changing.
i tried below formula but still unable to get what i need.
LC = ActiveSheet.Cells.Find("*", SearchOrder:=xlByColumns, SearchDirection:=xlPrevious).Column