Excel Experts,

Simple question. I've been away from VBA for a bit.

How do I select the current row.

I tried
Rows.CurrentRow.Select
but that didn't work.

Thanks,
Alan

ActiveCell.EntireRow.Select

Regards,
Stefi


€žachidsey€� ezt Ã*rta:

Excel Experts,

Simple question. I've been away from VBA for a bit.

How do I select the current row.

I tried
Rows.CurrentRow.Select
but that didn't work.

Thanks,
Alan

Sub selectcurrentrow()
Rows(ActiveCell.Row).Select
End Sub

--
Don Guillett
SalesAid Software

"achidsey" wrote in message
...
Excel Experts,

Simple question. I've been away from VBA for a bit.

How do I select the current row.

I tried
Rows.CurrentRow.Select
but that didn't work.

Thanks,
Alan

I forgot to add.
Perhaps you should post your code as it is rarely necessary or desirable to
select.
ie:
Rows(ActiveCell.Row).Copy Range("a23")
--
Don Guillett
SalesAid Software

"achidsey" wrote in message
...
Excel Experts,

Simple question. I've been away from VBA for a bit.

How do I select the current row.

I tried
Rows.CurrentRow.Select
but that didn't work.

Thanks,
Alan