Dustin S.,
Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).
Option Explicit
Sub calctest()
Dim number1 As Double, number2 As Double, answer As Double, RPM As Double, DIA As Double
Dim SFM As Integer, MAX As Integer, ALPHA As Integer
Dim NR As Long
SFM = InputBox("What is the SFM?")
ALPHA = InputBox("What Alpha symbol are you using?")
MAX = InputBox("What is maximum RPM for machine?")
NR = 23
DIA = Sheets("Feeds and Diameters").Range("B" & NR).Value
Sheets("Feeds and Diameters").Select
If ALPHA = 1 Then
ALPHA = Range("d23").Select
ElseIf ALPHA = 2 Then
ALPHA = Range("e23").Select
ElseIf ALPHA = 3 Then
ALPHA = Range("f23").Select
ElseIf ALPHA = 4 Then
ALPHA = Range("g23").Select
ElseIf ALPHA = 5 Then
ALPHA = Range("h23").Select
ElseIf ALPHA = 6 Then
ALPHA = Range("i23").Select
ElseIf ALPHA = 7 Then
ALPHA = Range("j23").Select
ElseIf ALPHA = 8 Then
ALPHA = Range("k23").Select
End If
Do Until Selection.Offset(0, -2).Value = ""
RPM = SFM * 3.82 / DIA
If RPM > MAX Then
RPM = MAX
Else
RPM = RPM
End If
number1 = Selection.Value
number2 = Round(RPM, 0)
answer = number1 * number2
Selection.Offset(0, 13).Value = Round(answer, 1)
Selection.Offset(1, 0).Select
NR = NR + 1
DIA = Sheets("Feeds and Diameters").Range("B" & NR).Value
Loop
End Sub
Have a great day,
Stan
Bookmarks