assigning a range based on a string

[Sean Thomas]

I'm having difficulties with this

how do I get the Userngname range to equal the range found by Username string?

Please Login or Register  to view this content.

[StephenR]

In your example, Userngname appears to be the same range as UseK2WCRng?

[Sean Thomas]

Well that's what I would like it to do but it fails

the idea was to run this procedure through a range and look up the range to use for the userngname range
however I am getting the string via username of "UseK2WCRng", but when I try to use this to assign it to userngname range so I can use it in the countifs formula it wont work

[StephenR]

It won't work because the value of Username ("UseK2WCRng") is not a named range. You have defined it as object (range) variable. It would work if you commented out

Please Login or Register  to view this content.

[Sean Thomas]

What I wanted to do was have a number of ranges already set as per

Please Login or Register  to view this content.

but then depending on what was in Sheet4.Cells(Rep.Row, "B").Value it would be able to use that particular range in my countif

[StephenR]

I think the way to do it is thus

Please Login or Register  to view this content.

[Sean Thomas]

Cheers Stephen, I will give it a go tomorrow
looks like it may work!