Hi,

These do different things, depends on what you really wnt to do.

Sub Macro1()
ActiveCell.Range("A1:E1").Select
End Sub
(Selects from activecell right to include five cells)

Sub Macro2()
Selection.CurrentRegion.Select
End Sub
(Selects the active "Region")

Thanks,

"edm" wrote:

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