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 gkittelson 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. LizzyAnn

    2 fax lines on 1 fax

    Any idea of whether or not it will mess with receiving/sending faxes?
  2. LizzyAnn

    2 fax lines on 1 fax

    Hey guys - am really in need of help on this one. We just finished going through a merger and are in the process of moving over fax lines & etc. Well, both Verizon (our service) and Cavalier (theirs) aren't really being all that cooperative about this, and the lease on the old building is up...
  3. LizzyAnn

    Phones are randomly resetting

    Norstar Meridian M7324
  4. LizzyAnn

    Phones are randomly resetting

    Ok, first I thought it was a fluke that last week one of the sale rep's phone decided to reset itself. (flashing and whatnot like when you first plug it in.) But it just happened again to the President's phone. (whoops!) Which now makes it a major issue. So what has been described to me is that...
  5. LizzyAnn

    Need to color code rows by column data

    Well, this time the header row colored itself. Oh well. I've just been informed that the prez no longer wants to do this (go fig.) That tends to happen a lot around here. Anyway, thanks for all your help, especially with setting up the queries and whatnot. I'm sure I'll be able to use that...
  6. LizzyAnn

    Need to color code rows by column data

    1004 Error, "No cells were found" highlights this: If rng.SpecialCells(xlCellTypeVisible).Rows.Count > 1 Then
  7. LizzyAnn

    Need to color code rows by column data

    Well, by the 1042nd row, everyone's had at least one row to their name.
  8. LizzyAnn

    Need to color code rows by column data

    Okie dokie. I just realized that sometimes some of the other columns are left blank. Dunno if that makes much of a difference. (A) Address 403 W. Pine Street (BLANK) 701 E. Pratt St. 1501 S. Clinton Street 8100 Cryden Way. 17 Stenersen Lane 51 Monroe Street (BLANK) (BLANK) 400 E Pratt St...
  9. LizzyAnn

    Need to color code rows by column data

    LIST: Sharod James Falco Benfield Chad Markle Kevin Brown Lynn Thompson Phil Arnold Dean DeSantis Edward Friel Rick Miller I'm not sure I can post the first few rows.. they contain personal data and all that junk.
  10. LizzyAnn

    Need to color code rows by column data

    last row.
  11. LizzyAnn

    Need to color code rows by column data

    Takes me to row 1042.
  12. LizzyAnn

    Need to color code rows by column data

    Yes. Column F is the one where the names are from the data, and I is where the "DataValueList" is.
  13. LizzyAnn

    Need to color code rows by column data

    Nothing. All blank.
  14. LizzyAnn

    Need to color code rows by column data

    Well, now all the cells are visible again... define what you mean by "Criteria
  15. LizzyAnn

    Need to color code rows by column data

    Ok, so I found the cells missing data and put the names in... But now.. no data found error... on this line: With rng.SpecialCells(xlCellTypeVisible).Interior
  16. LizzyAnn

    Need to color code rows by column data

    I expect there to be a name on every row.... that confuses me/
  17. LizzyAnn

    Need to color code rows by column data

    OK, so now I have the list of names colored, and now it hides all the rows except the ones w/o a name in the column...
  18. LizzyAnn

    Need to color code rows by column data

    Oh.. Didn't know that part.
  19. LizzyAnn

    Need to color code rows by column data

    Is there a reason they wouldn't be visible??
  20. LizzyAnn

    Need to color code rows by column data

    All rows are visible. I had some of the columns hidden though.

Part and Inventory Search

Back
Top