Highlight Active row

[erik.van.geit]

Hi Erik
I'm not sure what you suggesting. Any change to a worksheet by a macro (called by OnTime or not) clears the undo stack. So even if you call the macro by OnTime, the undo stack will be cleared.
Or did I just completely fail to get what you were saying?

As you know I'm not a "real programmer". Consequently this involves some limitations but also advantages. I will try out things which a programmer wouldn't, because he thinks it's not possible.
Perhaps my explanation in the other post was to short.

*if you absolutely want to use a cell, whithout the drawback, there is a trick: use running-clock on other (hidden) sheet and refer to there with a formula

If you change sheet1 by code, you will still be able to have undo on sheet2. It is not OnTime specific.

Put =Sheet1!A1 in some cell on sheet2.
Change something on sheet2.
Run this code (even mutiple times)

Sub test()
    With Sheets("Sheet1").Range("A1")
    .Value = .Value & "&"
    End With
End Sub

You will see that "&" is added on sheet1, reflected on sheet2, because of the formula. But you have still undo available!!

You have still Undi available, when you run

    With Range("A1")
    .Value = .Value & "&"
    End With

while sheet1 is active.

If you want, throw me an email. "time running in cell" I'll send you an example.

best regards,
Erik

 

[erik.van.geit]

Hey Erik,
Do you still have that bloody nose API joke code?

search for "bleeding nose"
http://www.mrexcel.com/forum/showthread.php?t=231988&highlight=bleeding+nose

 

[Greg Truby]

Oh, and Greg.... They make you live in a field?

Nope. You're a few minutes east and south.

 

[Oorang]

rofl When I posted that I hadn't figured out you had to remove the N & W So I just went to the coordinates. Hadn't actually realized that it would mean almost 60 miles

Nope. You're a few minutes east and south.

 

[ExcelChampion]

What Erik is saying is that it is not always true that running a macro will clear the stack. There are some things a macro can do that won't clear the stack. But, that is beside the point. The point here is how do you save the stack.