CurrentRegion in another Sheet

[Philosophaie]

Simple question. I want to select the current region from a different sheet then the current active sheet in a VBA subroutine.

Selection.CurrentRegion.Select

 

[GlennUK]

Your request makes no sense at all. The current region is where the active cell is located ... yet you want to select something that is not related to the active cell.

 

[Philosophaie]

I just want to select the entire region in another sheet.

 

[RoryA]

What entire region - the used range? (you can't actually select anything on a sheet that isn't the active one)