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 bkrike 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 fuzzyangel

  1. fuzzyangel

    using countif into a formula

    Thak you! All posts helped, but what was really helpful was the suggestion to use macro recorder. It was very difficult to find the right number and use of all these " characters, and recording really helped. The right syntax is ActiveCell.Formula = "=COUNTIF(" & first_cell & ":" & last_cell &...
  2. fuzzyangel

    using countif into a formula

    I want to put a formula in a cell, to check if a range of cells contains one character. I think it seems like ActiveCell.Formula = "=" & "COUNTIF(" & first_cell & ":" & last_cell & ";" & ""P"" & ")" where first_cell and last_cell are the bounds of a range and "P" is the character I want to...
  3. fuzzyangel

    Dont'want page breaks in union of ranges

    Hi I used VBA (I use Excel 5) to select two regions of a worksheet. The first is some headers (cells a3:bn5) and the second is one region (cells a7:bn7) that includes what I want to be printed. So I use union to selected these two regions. But in print preview (hence in the printout) the first...
  4. fuzzyangel

    finding part of text from a table imported from excel

    Is there a way to find a part of text from a table that i previously imported from excel? I don't want to use the find command from menu, because it needs much time and i have to search for 500 records. I want to give a part of text in a cell, then to find the first record that has this part of...
See more

Part and Inventory Search

Back
Top