Results 1 to 3 of 3

Autofill destination by columns

Threaded View

jeffreybrown Autofill destination by... 12-21-2009, 12:04 AM
davesexcel Re: Autofill destination by... 12-21-2009, 01:11 AM
jeffreybrown Re: Autofill destination by... 12-21-2009, 01:19 AM
  1. #1
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,327

    Autofill destination by columns

    How exactly do I autofill by columns?

    In this example I recorded a macro and cleaned it up autofilling through E1 but it could be a number up to 50.

    Sub Macro2()
    Dim i As Long
    i = InputBox("Enter number")
    Range("B1").AutoFill Destination:=Range("B1:E1"), Type:=xlFillDefault
    End Sub
    Last edited by jeffreybrown; 12-21-2009 at 01:20 AM.

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