2008/5/24 Jerry Feldman <[EMAIL PROTECTED]>:
> Here is a macro that I hard coded to increment a value in cell D2. I
> must admit that I found something similar online, but I need to start
> to learn OO.o macro languages in the next few weeks.
>
> Sub Incd2()
> mynum = Range("d2") + 1
> Range("d2") = mynum
> End Sub
>Thank you Jerry. I am having a hard time getting macros to run, I think that there is a problem with my java installation. In any case, I thank you for your work. As I have 3*50 cells that need to be updated in this fashion, I have been trying to figure out a non-hard coded solution. Ideally, I would simply click the cell to have it's value incremented, however, I do not see a onMouseClick type of condition for the cell functions. Dotan Cohen http://what-is-what.com http://gibberish.co.il א-ב-ג-ד-ה-ו-ז-ח-ט-י-ך-כ-ל-ם-מ-ן-נ-ס-ע-ף-פ-ץ-צ-ק-ר-ש-ת A: Because it messes up the order in which people normally read text. Q: Why is top-posting such a bad thing?
