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!
-
Congratulations bkrike 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: *
- Users: fuzzyangel
- Content: Threads
- Order by date
-
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...- fuzzyangel
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
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...- fuzzyangel
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
-
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...- fuzzyangel
- Thread
- Replies: 1
- Forum: Microsoft: Access Other topics
