Using cell contents to set a range variable

Question

I'm trying to run code on a range that changes through different iterations of a loop. Here is what I would like the code to run if the value in range("SearchBy") = ZeroCounts

Dim WorkRange As range
Set WorkRange = range("ZeroCounts")

Here is how I am attempting to solve this but I can't find a way that works without returning errors. Any ideas?

Dim dummy As String
dummy = """" & range("SearchBy").Value & """"

Dim WorkRange As range
WorkRange = Sheets("HungarianAlgorithm").range(dummy)

WorkRange.Select

Protip: when you ask a question about something that raises errors, it's usually a good idea to mention what the errors are. — Mathieu Guindon
– Mathieu Guindon, Commented Jan 11, 2018 at 18:54

Tim Williams · Accepted Answer · 2018-01-11 18:54:44Z

1

You need to use Set when assigning a value to an object-type variable

Try

Set WorkRange = Sheets("HungarianAlgorithm").Range(Range("SearchBy").Value)

answered Jan 11, 2018 at 18:54

Tim Williams

169k8 gold badges104 silver badges143 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using cell contents to set a range variable

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related