Recent content by Mizzness

Matty, Try using the Protect Worksheet function. This will prevent any unnecessary changes from unauthorized users.

Loomah / Blue, Both solutions work. Thanx. To quote Skip: "There is more than one way to skin a cat." A star for both of you.

Resolved this issue via a pivot table but would like to know if there is a flaw or issue with Excel that prevents you from using the "<" or ">" characters as a reference or part of a reference in a function.

Kurupt, Maybe I wasn't clear at first. The "<" & ">" characters are part of the heading used in the criteria of the CountIf function. The CountIf function is referencing the following formula: =IF(C13<8,"<8",IF(AND(C13>7,C13<16),"8-15",IF(AND(C13>15,C13<31),"16-30",IF(C13>30,">30")))) Example...

All. I have a table using the CountIf function in Sheet1 to capture data from Sheet2. The table is setup as: Fails By Age <8 (col.K) 8-15 (col.L) 16-30 (col.M) >30 (col.N) The CountIf function works for cols. L & M but not for K & N. Is this because the criteria contains...

Hmmm...seems strange. Why not just create a new List Box ? Based on your example I tried it and it worked fine. Have you checked the range of your list ?

XL, Does your List Box contain all 10 items ? If so you can just resize the box by righ-clcking on the box and dragging down one of the corners.

Thanks Skip, How could I also incorporate this if the last two digits are "19" ? I.E.: 2019 should be 2020. thanx again.

All. Presently I recorded the Find/Replace function to look for any data that had "19" & to replce it with "20". Upon further review of this data (in mm/dd/yyyy format)I would like to know if there is a way to code Find/Replace so that it only looks for the first two digits of the yyyy area ...

Made the change. Thanks again.

Exactly what I needed. Thanks Skip for all you help.

No problem. One last thing: how do you disengage the filter to show all the data ?

Yes. I get the following Run-time error '1004': "Unable to get the Specialcells property of the range class" Code: Sub Macro5() ' [A5].AutoFilter [A5].AutoFilter Field:=3, Criteria1:="=SP*" With [A5].CurrentRegion .Range(.Cells(2, 1), .Cells(.Rows.Count...

Skip, The result of the custom filter gives Row 56 the starting row with data that starts with "SP". I start at row 5 because that is where my header is. If my starting row for deletion changes (which it will) how do I adjust my code ? Thanx for your help.

All. Here is the posted code using the custom filter feature. My question is how do I adjust it to capture all rows once the filter is on when the first row changes daily ? From the code, today's data starts at row 56. Code: Rows("5:5").Select Selection.AutoFilter Selection.AutoFilter...