select range based on active range

**kingcashandcarry** · 01-31-2020, 10:43 AM

i want to navigate to right of an active range of cells not particular
so if i select range for example a3:a10 to offset to b3:b10
seems easy but i dont know why cant find the code

**CK76** · 01-31-2020, 10:53 AM

Not sure of the purpose. But you'd need VBA for this.

Ex:

Please Login or Register  to view this content.

Then add short cut key combo using Macros -> Options.

Select your range. Then hit key combo to offset column by 1.

**kingcashandcarry** · 02-01-2020, 03:00 AM

It was so easy how stupid of me.. thanks man work just perfectly.

select range based on active range

LinkBack

Thread Tools

Rate This Thread

Display

select range based on active range

Re: select range based on active range

Re: select range based on active range

Thread Information

Users Browsing this Thread

Similar Threads

Using offset function to select a range of cells based on active cell location

[SOLVED] How to select a range within the active column ?

Select a range from active cell

Select Range in Active Row

Select range from active cell

Select a Range Based on Active Cell Location?

[SOLVED] How to select range of Active Window

Bookmarks

Bookmarks

Posting Permissions