Thread: Simple Problem?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Allllen Allllen is offline
external usenet poster
 
Posts: 341
Default 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?