Range with a variable

[Animal via OfficeKB.com]

Hello there,

Can't understand why I can't find the solution to thins simple problem
anywhere.

Set d = Range("Year:" & c.Offset(-1, 0)).Find(Range("ReportYear"),
LookIn:=xlValues)

I don't know how to wright the syntax for a range which uses a variable. Must
be a common problem or? It workes when I do like this:
b = 1
Set d = Range("A" & b)
But when i want a range from "a" to "b" and use the symbol of ":" it doesn't
work.

Can someone help me please, I get an error all the time.
/Animal

 

[Guest]

Something like this?

Set d = Range("A" & b, "C" & f)

and b and f are numbers. CHange to suit.

 

[Animal via OfficeKB.com]

Thank you very much it worked of course.

I had already tried it, but nothing happend and I found another problem for
that in a merged cell.

Take care