+ Reply to Thread
Results 1 to 5 of 5

Set ranged from already set range - entire column without header

  1. #1
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Set ranged from already set range - entire column without header

    Hi Guys,

    I set range from CEll A2 to B13.

    How can i select entire column Header2 without header? (without cell B1).

    Screenshot_19.png

    Best,
    Jacek

  2. #2
    Forum Contributor
    Join Date
    09-21-2009
    Location
    Belgium - Mechelen
    MS-Off Ver
    Office 365 - version 2310
    Posts
    278

    Re: Set ranged from already set range - entire column without header

    This will select all cells with values within a column.
    i.e. : select cell B2, then selet all cells that have a value

    Please Login or Register  to view this content.
    Even a little help can be a big help !!
    1. A sample workbook says more then words. Add problem description and solution so we can understand the problem.
    2. Your appreciation is accepted by clicking the star "Add Reputation" at the lower left of the post.
    3. If your problem is solved, mark it as [SOLVED]: See "FAQ : " https://www.excelforum.com/faq.php
    4. Use [CODE] [/CODE] tags to illustrate your code: see here

  3. #3
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,084

    Re: Set ranged from already set range - entire column without header

    Maybe something like
    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: Set ranged from already set range - entire column without header

    thank you Guys!

    Working, nice!

    Best,
    Jacek

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,084

    Re: Set ranged from already set range - entire column without header

    Glad we could help & thanks for the feedback

+ 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. copy entire row from sheet1 into sheet2 matching ID and column header
    By dileepkmr319 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-18-2018, 12:02 PM
  2. [SOLVED] how to make my one row macro work on the entire column, also have header on row 1
    By dmcgov in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 01-28-2016, 12:19 PM
  3. Add certain text to entire column (except header)
    By Excelsemi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-30-2014, 11:30 AM
  4. [SOLVED] Sum entire column based on header name
    By excelhelporfavor in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-13-2014, 10:17 AM
  5. Replies: 1
    Last Post: 10-05-2013, 03:35 PM
  6. [SOLVED] Formula Needed to Return Entire Column Under Header on Second Sheet
    By bigtunelover in forum Excel General
    Replies: 1
    Last Post: 01-27-2012, 11:19 PM
  7. How to format an entire column except Header
    By twilson148 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 06-12-2010, 10:56 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