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)