Hi Ron,

I've tried selection but it doesn't do what i want.
I need the row addresses for the selected lines.
The selection object gets damaged during the row processing and saving it
to a local variable doesn't seem to work - it stays as an empty variable.

Perhaps you need to explain what is that you wish to do with the selected
rows, but perhaps you could adapt one of the following:

Dim Rng As Range
Dim rw As Range
Dim i As Long

Set Rng = Selection

'To iterate the selected rows
For Each rw In Rng.Rows
' do something e.g.:
MsgBox rw.Address
Next

'Or, to selectively delete rows:
For i = Rng.Rows.Count To 1 Step -1
If IsEmpty(Rng.Rows(i).Cells(1)) Then
Rng.Rows(i).EntireRow.Delete
End If
Next i

---
Regards,
Norman



"Ron" wrote in message
news:42f00f2e.0@entanet...
Hi again,

I'm trying to process rows that a user has selected before starting the
macro.

I've tried selection but it doesn't do what i want.
I need the row addresses for the selected lines.
The selection object gets damaged during the row processing and saving it
to a local variable doesn't seem to work - it stays as an empty variable.

Can anyone help ?

Thanks,

Ron


"Trevor Shuttleworth" wrote in message
...
Ron

try looking at selection.

For example:

For Each cell In Selection
' do something
next 'cell

Regards

Trevor


"Ron" wrote in message
news:42efef0f.0@entanet...
Hi,
I'm trying to process rows that a user has selected before starting the
macro.
I have managed to get the process running by using ActiveCell but that
doesn't seem to know where the other selected rows are, just the first
one.

I have looked at collections and shapes but i don't seem to get any
values or objects returned.
I'm probably missing something very obvious here,

Thanks in advance

Ron
(drop the xxx's to reply directly)