mushy_peas < wrote:

Is there a way to specify a range based on a varible, for example


Range("Asomenumber").Select

eg. where somenumber = 5, so that A5 in this case is selcted, but if
somenumber changed then another cell selected.


SomeNumber = 5
Range("A" & SomeNumber).Select

Will get you to A5.

Regards,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.