Simple Problem?
This works. You should be able to figure it out from this. Lose the colon.
Sub animals()
frog = "B"
cow = "1"
horse = "C"
sheep = 6
Range((frog & cow), (horse & sheep)).Select
End Sub
--
Allllen
"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?
|