find last occurence of x

[jarhead58]

Hello everyone!

I'm looking for the easiest way to find the last time "X" occured in a column via a module I'm calling test for now. Specifically, find the last time "X" occurs in col g on sheet2 lets say, if true, offset(7, 0) and then put "X" in that cell from the offset. TIA

 

[Rick Rothstein]

Try this in your macro...

Sheets("Sheet2").Columns("G").Find("X", , , xlWhole, , xlPrevious, False, , False).Offset(7) = "X"

 

[jarhead58]

Try this in your macro...

Sheets("Sheet2").Columns("G").Find("X", , , xlWhole, , xlPrevious, False, , False).Offset(7) = "X"

Thank you so much for that! I tried doing something with a For Next but it kept erroring.

Now also have dates in column a starting at row 2 on the same page. Would I use something like, If sheets("sheet2").range("G2:G26").value <> "X" AND

sheets("sheet2").range("A2:A26") = TODAY() Then, not sure how to format this, make this cell value "X". Would that work​

 

[Rick Rothstein]

Then, not sure how to format this, make this cell value "X".

Make what cell "X"... the one with in Column A with the date in it?

 

[jarhead58]

Sorry about that! The intersecting cell of Today() in col A and col G, eg, A6 and G6

 

[Rick Rothstein]

Sorry about that! The intersecting cell of Today() in col A and col G, eg, A6 and G6

Will a cell equal to TODAY() appear only once in Column A or could today's date appear more than once in Column A?

If more than once, are we supposed to put the "X" in Column G for only the last today date for do it for all the today dates?

 

[jarhead58]

Will a cell equal to TODAY() appear only once in Column A or could today's date appear more than once in Column A?

If more than once, are we supposed to put the "X" in Column G for only the last today date for do it for all the today dates?

Just once and thank you for the reply and time sir!

 

[jarhead58]

I still haven't got it figured out yet

 

[jarhead58]

Mr. Rothstein

Were you able to come up with anything that would help with the above?