Multiple range based on a particular column

[[email protected]]

Hi,

Kindly help to correct the below code. I need to select Column M,N, R,Y and Z to the row limit of column "A".

Please Login or Register  to view this content.

Regards,

Prabhu

[berlan]

Try:

Please Login or Register  to view this content.

Cheers, berlan

[:) Sixthsense :)]

Please Login or Register  to view this content.

[Richard Buttrey]

Hi,

Use a variable. i.e.

Please Login or Register  to view this content.

Incidentally you probably don't need to select the range. If you want to copy itg or delete it or do something else with it just use the appropriate instruction, e.g. replace .Select with .Copy

Selecting stuff just slows things down. It's one of the disadvantages of never modifying code that's captured by the macro recorder which is almost always beneficial.

[[email protected]]

Thanks All !!