+ Reply to Thread
Results 1 to 4 of 4

working with columns index in range

  1. #1
    Forum Contributor
    Join Date
    01-18-2013
    Location
    Prague, Czech rep.
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    138

    working with columns index in range

    Hi guys,

    I´m wondering if there is a way how to write this in vba:

    usual way of selecting:
    Please Login or Register  to view this content.
    alternative
    Please Login or Register  to view this content.
    and here comes my question:
    usual way of selecting:
    Please Login or Register  to view this content.
    alternative
    Please Login or Register  to view this content.
    thx a lot

    Soul

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: working with columns index in range

    Hi,

    Something like?

    Range(Columns(3),Columns(5)).EntireColumn.Select

    Or perhaps like?

    Union(Columns(2),Columns(3)).Select
    Last edited by MarvinP; 02-04-2015 at 08:41 AM.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,431

    Re: working with columns index in range

    another alternative

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  4. #4
    Forum Contributor
    Join Date
    01-18-2013
    Location
    Prague, Czech rep.
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    138

    Re: working with columns index in range

    Hi guys,

    was busy and off the net, yeah both works perfectly, tried and solved my issues once again thx a lot

    see you around

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Return Row Index and Column Index of a Cell in a Range
    By exceere in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 01-06-2015, 04:54 AM
  2. Correct/Working (Index,Match) formula not working between cells
    By barnerd in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 02-11-2014, 01:20 PM
  3. [SOLVED] Long array formula with INDEX and MATCH quits working when range is too large
    By UncleKevy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-05-2013, 09:42 PM
  4. Replies: 2
    Last Post: 05-24-2013, 09:32 AM
  5. Increment columns in INDEX and MATCH formula - ROWS and COLUMNS
    By nickmangan in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2012, 10:38 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1