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!

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

Recent content by Randy1234

  1. Randy1234

    Getting Values Based on Conditions

    I fixed my own problem, but it loops rather slow. If anyone has an idea to spped it up a bit I would greatly appreciate it. Here is the code I am using: Sub Starts() Dim rng As Range Dim Cell As Range Set rng = Range("C6:AD1505") For Each Cell In rng With Cell If...
  2. Randy1234

    Getting Values Based on Conditions

    I have a spreadsheed that is pulling data from another worksheet, sorting it then using that data to fill in the cells on my report. 1. Column "a" is a project name and Column "b" of the is a start date. 2. Columns "c" through "ad" are weeks where Row 2 contains dates for the begining of each...
  3. Randy1234

    annoying problem with excel mouse pointer

    Very cool...I learn something new every day.
  4. Randy1234

    annoying problem with excel mouse pointer

    I would cut the row and and insert above the row where you want it. For example, say you are working with rows 16, 17 and 18, and you want to put row 18 above 17. Step 1) Select row 18 by clicking on the row number and "cut" it. Step 2) Select row 17 and "Insert" "Cut Cells" You can use the...
  5. Randy1234

    Loop through rows completing tasks in each row conditionally

    Got it...thanks to all. I just realized my initial range included the field headers and that was giving me the error. Once moved the start of the range from Z1 to Z2 everything worked out great!!
  6. Randy1234

    Loop through rows completing tasks in each row conditionally

    Thanks, but neither fix worked. The first fix I had already tried and received the same error. The second fix gave me a new error: "Reference is not valid".
  7. Randy1234

    Loop through rows completing tasks in each row conditionally

    I need a little assistance with a code that I am writing for one of my worksheets. Here is what I am trying to do: 1. loop through each row 1-200 2. If the cell in column "Z" is > 0 then 3. Goalseek the cell in column "AS" of the same row to 0.25 by changing the cell in column "X" of the same...
  8. Randy1234

    Setting Ranges to Format in VBA

    Skip you are an absolute genious. I will definitely give credit where credit is do. Looking at your logic, I can see what I was missing. Thank you so much for your help. You Rock!!!
  9. Randy1234

    Setting Ranges to Format in VBA

    The code range is in column A. The values for the code range will be S, O, E, F, EE and P. Colors are assigned to each of these codes. The track range falls from Column G through column BB(one column per month for 4 years). The values for the track range are numeric. When I enter/change a...
  10. Randy1234

    Setting Ranges to Format in VBA

    That didn't work...it colored some cells and blanked out ohers. It also took a while to run through the loop. I have no idea where to turn now. Thanks for the help
  11. Randy1234

    Setting Ranges to Format in VBA

    Thanks Skip...that works fine for just row 18, but I am looking to run this through the entire worksheet so whenever I change the value in cloumn A the cells in the same row will change to the appropriate color if they contain values. Example: If I type s in A18 then the cells in G18:BB18 will...
  12. Randy1234

    Setting Ranges to Format in VBA

    Hi Everyone, I have a major issue that I hope can be solved since I have spent about three days trying to figure this one out. I have text in range1 ("A18:A300") but not in every cell. There are also numerical values in range2 ("G18:BB300") but not in every cell. As the values change in...
See more

Part and Inventory Search

Back
Top