Loop through user selection.... 1

[Johnny42]

How would I loop through a user selection....
I use this , however the sheet must be the active one.....


For Each cell In Selection.Rows
'do.....
Next Cell

I would like something like this ..
For Each cell In Sheet("usersection").Selection.Rows
'do.....
Next Cell

 

[SkipVought]

Hi,

Isn't it the ActiveSheet that the user is selecting cells in???

The Selection Object is not available on anything but the ActiveSheet

You could have set a reference when the selection was made on the other sheet and then use that range reeference

'we're on Sheet1
set rng = selection
sheets("Sheet2").activate
for each c in rng.rows
  '
next

Skip,

_{[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart!}

 

[Johnny42]

Thanks Skip,
Yes the user would be on the active sheet, however I like things a bullet proof as possible....