+ Reply to Thread
Results 1 to 2 of 2

Range.EntireColumn doesn't function properly, what is wrong with my code?

  1. #1
    Forum Contributor
    Join Date
    12-03-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    107

    Range.EntireColumn doesn't function properly, what is wrong with my code?

    My code follows:

    Please Login or Register  to view this content.
    When I Run the code I thought it was supposed to highlight the entire column A, but instead it highlights columns A to F which consists of my entire table.

    But when i try using .EntireRow like this:

    Please Login or Register  to view this content.
    The code works as how I would want it and it highlights the entire first row. What am I doing wrong here? What did i do wrong with the .EntireColumn function?

  2. #2
    Forum Contributor
    Join Date
    12-03-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    107

    Re: Range.EntireColumn doesn't function properly, what is wrong with my code?

    Nevermind, solved it already. Merged columns are the culprit.

+ 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. why does the code Range("A1:A50") work and Range(A1).entirecolumn doesnt?
    By kjy1989 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-29-2013, 03:22 AM
  2. [SOLVED] Event macro runs in wrong workbook/doesn't work properly
    By VBA FTW in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-30-2012, 11:28 AM
  3. [SOLVED] VBA code running in wrong order and not executing properly
    By ollylondon in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-21-2012, 10:11 AM
  4. [SOLVED] New Code Copy Doesn't Work properly
    By Kyle123 in forum Suggestions for Improvement
    Replies: 3
    Last Post: 07-18-2012, 08:00 AM
  5. VBA function doesn't work properly
    By sumonrezadu in forum Excel General
    Replies: 4
    Last Post: 08-28-2009, 09: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