+ Reply to Thread
Results 1 to 3 of 3

Cannot select and pull down cells to copy, after applying a Macro

  1. #1
    Registered User
    Join Date
    12-06-2012
    Location
    Pittsburgh,Pennsylvania
    MS-Off Ver
    Excel 2007
    Posts
    5

    Cannot select and pull down cells to copy, after applying a Macro

    I was messing around with some Macros, as an issue came up where clients were pasting over Data Validated cells (thus removing the validation). Somehow though, the feature where you can select a cell, then pull the active cell down through the column (and then can copy, fill series, etc)has become disabled. I deleted all the macros, and turned them off in the Trust Center, but when I click on a cell the box and plus sign still won't display for me to pull the cell down the column. Any idea of what I may have done to disable this feature? I use it everyday, so it'd be helpful to get it back. Thanks!

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Cannot select and pull down cells to copy, after applying a Macro

    Hi,


    Check in the Excel Settings.

    Under the Advanced Editing options, has the 'Enable fill handle and cell drag & drop' option been deselected?
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    12-06-2012
    Location
    Pittsburgh,Pennsylvania
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Cannot select and pull down cells to copy, after applying a Macro

    Awesome, that fixed it. You just saved me a thousand headaches. Thanks much!

+ 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. VBA error Next Without For - applying macro to select worksheets
    By haskenazi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-24-2014, 10:58 PM
  2. [SOLVED] vba/macro select last two cells and copy down
    By GaryDML in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-30-2013, 02:22 AM
  3. Replies: 4
    Last Post: 06-04-2013, 11:01 AM
  4. [SOLVED] Want macro to select & copy cells from a different worksheet
    By RocketRod in forum Excel General
    Replies: 5
    Last Post: 02-28-2006, 09:00 AM
  5. [SOLVED] How can my macro select an option in a pull down menu?
    By Tim Richards in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-06-2005, 07:06 PM

Tags for this Thread

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