Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I have just started using Excel 2003 and VBA in Excel. So I hope no one laughs at me. Ok I have a worksheet that I am working with that changes a percentage (increases by .001%) so that two numbers equal each other. The Percent amount starts at 1% (which doesn't need to be shown in the code). I've been working with this subroutine: Sub AddPercentage() Dim NumberA, NumberB, Percent As Integer Number1 = Range("I16") Number2 = Range("K16") Percent = Range("L7") If Not Number1 = Number2 Then Percent = Percent + 0.00001 End If End Sub Can someone help me out here? I would really appreciate it. :) -- Jeff Roper ------------------------------------------------------------------------ Jeff Roper's Profile: http://www.excelforum.com/member.php...o&userid=16293 View this thread: http://www.excelforum.com/showthread...hreadid=276913 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula question from beginner | Excel Discussion (Misc queries) | |||
Beginner Question | Charts and Charting in Excel | |||
Beginner question! | Excel Discussion (Misc queries) | |||
Beginner question | Excel Discussion (Misc queries) | |||
Beginner VBA question | Excel Programming |