I'm continually frustrated in trying to learn VBA to do some things
which I think would be useful tools (well, for myself anyway).

I'm not bright, but MS Office is certainly not new to me.
I do want to learn VBA, more than anything, at this point, instead of
relying on your peoples' wonderful help. And I do mean wonderful, as
I've gotten lots of good answers here, but I hate being bothersome.

But, I cannot for the life of me figure out the code to do a simple
division program, as follows.


Row A contains the values 1 to 100 (each number in its own cell).

In the code, I want each of the Row A numbers to be tested if:

If the number from Row A = or ends in 0, 2, 5 Then go to the next
number in sequence.

If the number does not end in 0, 2, or 5. , but is 2
Then divide it by 3.

If the answer leaves a remainder, then put that answer in Row C,
starting from the left-most column. Then, on to the next number in
Row A, and test, and divide and so on to 100.

I've long wished I had some of you folks ability to whip up these
programs on the fly.

Please help