Activecell.Resize(,5).Select

--

HTH

RP
(remove nothere from the email address if mailing direct)


"edm" wrote in message
ups.com...
Hi

In the "Range("A5:E5").Select" statement I need to make the A5:E5 part
of it change as to whatever the active cell is at the time. I have no
idea as to what it will be before hand. Can anyone help me?

Erle