Hi all,
Please help!
I'm having a difficult time trying find a way to change the bolded values using an input box instead of manually changing "intR = intS To value" for the cells that I need the code to look at.
I am noobie to coding and any amount of help is greatly appreciated! Thank you!!!![]()
intS = 3 For intR = intS To 19 Windows(strFile).Activate strA = Sheets(strSheet).Cells(intR, 35).Value For A = 1 To 8 If A = 1 Or A = 2 Or A = 3 Or A = 4 Or _ A = 5 Or A = 6 Or A = 7 Or A = 8 Then Windows(strIDFile).Activate strPlanID = Sheets(strSheet).Cells(intRegion, (intPlan * 3) + 8).Value dblAdultRate = Sheets(strSheet).Cells(intRegion, (intPlan * 3) + 9).Value dblChildRate = Sheets(strSheet).Cells(intRegion, (intPlan * 3) + 10).Value If intR = intS And A = 1 Then Workbooks.Open Filename:=strDirectory & strTemplate Windows(strTemplate).Activate Sheets("Table").Activate Range("B6").Select Selection.FormulaR1C1 = str1 Range("B7").Select Selection.FormulaR1C1 = str2 Range("B8").Select Selection.FormulaR1C1 = dt3 Range("B9").Select Selection.FormulaR1C1 = dt4 intRowKnt = 14 End If Next A
Bookmarks