+ Reply to Thread
Results 1 to 7 of 7

Code causing buffering issues with column selection

  1. #1
    Valued Forum Contributor
    Join Date
    11-27-2013
    Location
    Brooklyn, NY
    MS-Off Ver
    Office 365
    Posts
    1,154

    Code causing buffering issues with column selection

    Hello,
    The below code is situated in a sheet and when i try selecting columns anywhere within the sheet excel buffers for about half a minute
    Not sure what part of the code is causing this but i would really be grateful to anyone who can point me in the right direction.

    Please Login or Register  to view this content.
    Last edited by kosherboy; 04-01-2016 at 02:58 PM.

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,663

    Re: Code causing buffering issues with column selection

    Maybe ...

    Please Login or Register  to view this content.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    4,638

    Re: Code causing buffering issues with column selection

    Is there some circonstances when the issue happen: A large range of cells selected ?
    For me with no value in the sheet and doing the selection of one cell, it is OK
    Can you send a sample of you file
    - Battle without fear gives no glory - Just try

  4. #4
    Valued Forum Contributor
    Join Date
    11-27-2013
    Location
    Brooklyn, NY
    MS-Off Ver
    Office 365
    Posts
    1,154

    Re: Code causing buffering issues with column selection

    Quote Originally Posted by PCI View Post
    Is there some circonstances when the issue happen: A large range of cells selected ?
    For me with no value in the sheet and doing the selection of one cell, it is OK
    Can you send a sample of you file
    Lately i've been having trouble uploading files onto this forum.
    I put the code into a blank sheet and when i selected several columns the buffering started.

  5. #5
    Valued Forum Contributor
    Join Date
    11-27-2013
    Location
    Brooklyn, NY
    MS-Off Ver
    Office 365
    Posts
    1,154

    Re: Code causing buffering issues with column selection

    Quote Originally Posted by shg View Post
    Maybe ...
    Yes, that worked!
    Can you explain to me what i did wrong in the code and why it was acting funny?

  6. #6
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,663

    Re: Code causing buffering issues with column selection

    If you selected the whole column, the code would have to ratchet through a million cells. If you selected the whole sheet, 17 billion.

  7. #7
    Valued Forum Contributor
    Join Date
    11-27-2013
    Location
    Brooklyn, NY
    MS-Off Ver
    Office 365
    Posts
    1,154

    Re: Code causing buffering issues with column selection

    Wow! I wouldn't want that to happen.
    Thanks for explaining it to me.

+ 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. Excel to Outlook Calendar date duplication issues and blank cells causing issues
    By singerbatfink in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 02-11-2016, 08:07 AM
  2. [SOLVED] Excel to Outlook Calendar date duplication issues and blank cells causing issues
    By singerbatfink in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 02-11-2016, 07:57 AM
  3. Moving to Excel 2010 and line of code causing issues (ungrohp)
    By andyd2k in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-28-2014, 08:53 AM
  4. Auto adjusting column width causing issues
    By ericaop in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-10-2013, 08:39 AM
  5. [SOLVED] Sorting by column issues with expanded selection
    By Abuba3000 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-17-2013, 12:51 PM
  6. Code to find last Column keeps causing an error
    By dwhite30518 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 06-01-2012, 07:03 PM
  7. Negative value causing issues
    By Speedbird1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-01-2008, 10:24 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