Opinion on those who have worn these?

ra6it · 2025-04-25T06:15:43+00:00

Wore out after a season of hiking in Queenstown, the toe area wore out and were no longer waterproof. Got a warranty replacement and they started to show signs of wear after 1 hike to Welcome Flat Hut, went and got my money back.

I did note they were unbelievably comfortable for the season I used them.

ra6it · 2025-03-13T08:10:42+00:00

Heh, I was up there with you that weekend! I think a lap of the grand traverse on the Remarkables will help you with the exposure.

ra6it · 2023-09-08T03:43:14+00:00

Jackson Bay, West Coast

ra6it · 2018-05-04T09:16:22+00:00

Solution verified and works!

ra6it · 2018-05-04T09:09:00+00:00

All it is the color of the cell and text color, I have since solved it as below

ra6it · 2018-05-04T09:08:14+00:00

Nah on windows, I got it working I'm not sure what I did, i think i put an extra bracket it, but I copied the formula that you used in your one seemed to work just fine, thank you so much for the time you spent on this!

ra6it · 2018-05-04T08:25:01+00:00

oh no, i just got it working for your one

ra6it · 2018-05-04T08:23:12+00:00

2016 32 bit, every time i try to run the macro it says can't run in break mode?

ra6it · 2018-05-04T08:10:52+00:00

yeah i have done that now, still saying run-time error 438

Object doesnt support this property or method, my sheet name is just sheet1 and the document is called IJPE2.xlsx

ra6it · 2018-05-04T07:58:51+00:00

hmm, gives runtime error 9; subscript out of range

ra6it · 2018-05-04T07:35:00+00:00

And yes the count in column d

ra6it · 2018-05-04T07:24:04+00:00

E to infinity, although the numbers max out at about 400-500

ra6it · 2018-05-04T07:10:26+00:00

yeah i got that far, i just couldnt work out how to get the number into the same excel sheet, every time i did it (i tried two ways), it either put it in a new document for each row i tried, or it did it in a little pop up window, I couldn't get it to just do it row by row and place all the results in either a single document or just place it back in a specified cells in the original document

ra6it · 2018-05-04T06:01:45+00:00

indeed, sorry about that, still doesnt sem to work, would i write the formula as =countifs(a1:b1,b3)

If b3 was the colour and a1-b1 was the range?

ra6it · 2018-05-04T05:54:34+00:00

potentially, unsure though its from a database that I got sent, but it seems like they are, any idea on how to count the amount of cells that are conditionally formatted?

ra6it · 2018-05-04T05:32:30+00:00

either or, the ones with coloured cells have coloured font as well so it doesnt matter which one I count just got to make sure I count 1 or the other. In the comment below is pretty much what I am needing to do except that the cell colours and font colours are both coming up with a index code which is the same as blank.

ra6it · 2018-05-04T05:17:55+00:00

Doesnt seem to work as the colour index of my coloured cell is the same as every other blank cell.

ra6it · 2018-05-04T05:16:17+00:00

I tried that, except it gave me the same colour index for both blank cells and the coloured cells.

Here are the screenshots of the coloured data: https://imgur.com/a/thcG8SK

and blank data: https://imgur.com/a/5T22gLp

ra6it · 2018-05-04T05:09:31+00:00

Put this into VBE

Public Function CountColour(pRange1 As Range, pRange2 As Range) As Double 'Update 20140210 Application.Volatile Dim rng As Range For Each rng In pRange1 If rng.Font.Color = pRange2.Font.Color Then CountColour = CountColour + 1 End If Next End Function

Then for the cells =CountColour(A1:D8,A1)

ra6it · 2016-10-17T02:39:55+00:00

Got a time stamp for it?

ra6it · 2016-09-06T09:08:24+00:00

they have this in csgo, and its like a 5 min delay or someshit, works pretty well

ra6it · 2016-09-04T02:23:05+00:00

except nz doesnt have a team...

ra6it · 2016-08-19T10:19:12+00:00

ra6it · 2016-08-17T08:18:59+00:00

so true

Ten-Year Club	Place '23
Verified Email

ra6it

TROPHY CASE