Find last Column in a specific row

[Aswinraj]

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

 

[MARK858]

Where in Row A9 -> Need to find last Column (J9) -> Insert "X" in Next row (K9).

You mean next column not row.

Rows(9).Find("*", , xlValues, , xlByColumns, xlPrevious).Offset(, 1).Value = "X"

Btw, it is VBA code not a formula.

 

[Aswinraj]

@MARK858 Yes you are right.., its a Column but i am getting an error as below,

I tired the same formula to add next to last pivot column.

 

[MARK858]

You can't add the x if it is within the Pivot table range using that method, it is a calculated field.

 

[Aswinraj]

@MARK858 Yes Sir.., but i am Pivot table range ends at Column J (Which is the last column in Pivot table.., and i am trying to add "X" in K column.

In Simple, i am trying to add "X" in a column next to last available Pivot table column.

 

[MARK858]

The code works fine for me if the cell the x is being inserted in is outside the Pivot table .

 

[Aswinraj]

@MARK858 Sorry my bad.., given incorrect offset range. Now it works. Thank you so much

 

[MARK858]

You're welcome