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 Westi 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. Anastomosis

    noob question about collections

    Thanks a lot, both Skip and fumei. I ended up using both after I checked on dictionaries (since I have experience in Python). Peace!
  2. Anastomosis

    noob question about collections

    Hi, I have just started with VBA, and I have a question that I cannot seem to answer using the documentation or other web pages. Are Collections immutable or something? If I add an element using Add, then try to change that value, it gives me a "Run-time error '424' Object required" error...
  3. Anastomosis

    Assigning Font format by Cells

    Awesome, that worked. Thanks. I'm C++ trained and still getting used to these object references.
  4. Anastomosis

    Assigning Font format by Cells

    Hi, fairly new to VBA here, and had a problem I just could not figure out. I'm just trying to bold the cells in the top row, row A. When I use this line in one of my Functions: Worksheets("Sheet1").Range(Cells(1, 1), Cells(1, 14)).Font.Bold = True I get an error that says "Error '1004'...

Part and Inventory Search

Back
Top