Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Feb 2003
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Automatic copy down (2003)

    I have been writing some code that sets/ resets hotkeys such as the drag and drop feature. I'm not sure if this is the cause but I no longer have the feature where there is a little black square in the lower right corner of the selected cell. I used to be able to double click on this little black square and the formula from that cell would be automatically copied down to the bottom of the adjacent range.
    How do I restore this feature?

    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Automatic copy down (2003)

    Select Tools | Options...
    Activate the Edit tab.
    Tick the check box "Allow cell drag and drop".
    Click OK.

    Or execute this line from the Immediate window in the Visual Basic Editor:

    Application.CellDragAndDrop = True

  3. #3
    3 Star Lounger
    Join Date
    Feb 2003
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatic copy down (2003)

    Thanks

Posting Permissions

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