Results 1 to 4 of 4

Auto fill

Threaded View

Hein Auto fill 10-28-2011, 02:57 PM
arlu1201 Re: Auto fill 10-28-2011, 03:01 PM
Hein Re: Auto fill 10-28-2011, 03:10 PM
arlu1201 Re: Auto fill 10-29-2011, 06:57 AM
  1. #1
    Forum Contributor
    Join Date
    06-29-2005
    Posts
    201

    Auto fill

    Hi all,

    Is it possible to make some VBA procedure to make the autofill procedure a little easier.
    As you can see in the demo I have some names in column D.
    In column C i want the numbers 1, 2 etc

    Now I do this by entering the 1 and 2 and than dubbelclick on the square if you select both cells.
    This means that I have to remove my hand from the keyboard to use the mouse, and that lots of times

    Is there some procedure that captures this so that
     Selection.AutoFill Destination:=Range("C5:C16")
        Range("C5:C16").Select
    can be done with a key combination.

    Thanks in advance
    Hein
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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