Select All Objects in Selection

[SIGE]

Hello,

Anybody has a VBA-routine that selects all objects within a selection?

i.e. it will select the objects in any random range I wish to select on my sheet.

Thanks for your insights,
Sige

 

[Ruddles]

This would be the .Select method.

Do you want to select a single contiguous range or multiple ranges? Or do you actually want to select a random range?

 

[SIGE]

Hi Ruddles,

A single contiguous range would suit my purpose:

Brgds Sige

 

[Ruddles]

Range("A1:F20").Select

You'd have been quicker Googling it or simply recording a macro and then examining its contents.