Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
#1 How to best learn VBA? #2 Division problem question
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Division and formatting excel question | Excel Discussion (Misc queries) | |||
Division | Excel Worksheet Functions | |||
Time Division Question | Excel Discussion (Misc queries) | |||
excel division formula question | Excel Worksheet Functions | |||
Division problem | New Users to Excel |