Thanks, Dom for your help. Works great. I really struggled with it before
posting.


wrote in message
oups.com...
Put everything inside a string. In your example, the quotes and
parenthesis are all out of place, and you aren't putting the colon
within the string.

For example, using your example, try this:

dim r as string
r = "f" + cstr (c.row) + ":" + "f" + cstr (tendr)

call activesheet.range (r).select

Hope this helps,
Dom



Ed wrote:
I need to activate a range using some variables - like so:
range("("f" & c.row):("f" & tendr)").Activate

I've tried every combination I can think of, over and over again, but
nothing I can come up with will work. Can someone help me, please?