Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. elcid113002

    Nested? For...Next statement in a loop???

    I appreciate everyone's replies. Skip, Your replies have generated more questions. Is nesting of For..Next even possible?? If so, How do i do it without getting the results I am getting? Another question about the copy/paste idea...If Range("J" & Variable) and Range("K" & Variable), How would...
  2. elcid113002

    Nested? For...Next statement in a loop???

    Sorry, I was trying to be as brief, but detailed as possible...To answer your questions, The dates are the dates of the detachment. Each day they rate OT. The hours are as follows: Total Pay OT Hrs w/o OT Base Pay H J K 58 1 $93.94 $46.97 59...
  3. elcid113002

    Nested? For...Next statement in a loop???

    Since (For MNum = 2 To LNum) why wouldn't LNum start at 2 then loop to 3, 4, 5, all the way to 12(N4 value)? Thanks, Elcid113002
  4. elcid113002

    Nested? For...Next statement in a loop???

    The groups of names will be paid overtime on the last day of a detachment I have copied a group of names from "Data" worksheet (J2 - J13) to "Attach" worksheet for each day they will be on Detachment (ie, May 13, 14, 15, 16 etc...) May 13 Name1 (base $$$)K54 May 13 Name2 (base $$$)K55 May 13...
  5. elcid113002

    Nested? For...Next statement in a loop???

    Private Sub FixData2_Click() Dim KNum Dim LNum Dim MNum Dim PNum Dim RNum Dim TNum Dim Counter Dim Check Check = True: Counter = 0 KNum = Range("N2").Value ' Should be equal to "2". LNum = Range("N4").Value RNum = Range("N12").Value If KNum = 2 Then Range("K" & RNum).Select...

Part and Inventory Search

Back
Top