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 John Tel 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 goman19

  1. goman19

    select cell range using For loop

    For w = 2 To totrows Range("B" & w).Select With Selection.Borders(xlEdgeRight) .LineStyle = xlContinuous .Weight = xlMedium .ColorIndex = xlAutomatic End With If Range("G" & w).Value = "yes" Then Range("C" &...
  2. goman19

    select cell range using For loop

    It says "Expected: list separator or )" and highlights the ":G" Any other ideas?
  3. goman19

    select cell range using For loop

    I'm trying to select a range of cells all on one line using the command Range("C:G" & w).Select where w is the for loop count variable. I keep getting a 1004 error so I replaced the C:G with one statement for each cell (C, D, E, F, G) which is ugly but works: Range("C" & w).Select ...
  4. goman19

    delete records in Access through ABODB in Excel

    Skip, I don't follow. Think of me as the worst programmer you've ever met. I can read code and understand it but I need the details thoroughly explained.
  5. goman19

    delete records in Access through ABODB in Excel

    Perfect!
  6. goman19

    delete records in Access through ABODB in Excel

    I have experience coding in several languages (VBA not being one of them) and am trying to teach myself enough VBA to write intelligent macros in Excel and Access. I have gleaned a lot of the necessary code off the internet and managed to figure out how to add Excel records into Access but want...
See more

Part and Inventory Search

Back
Top