Results 1 to 3 of 3

Fill range across and down

Threaded View

tone640 Fill range across and down 08-17-2011, 05:28 AM
Steffen Thomsen Re: Fill range across and down 08-17-2011, 05:54 AM
tone640 Re: Fill range across and down 08-17-2011, 06:00 AM
  1. #1
    Forum Contributor
    Join Date
    06-15-2011
    Location
    Chester, England
    MS-Off Ver
    Excel 2013
    Posts
    117

    Fill range across and down

    The below does not work because I am trying to fill across and down (E2:J103) in one step.

    Sub Macro1()
    
        Range("E2").FormulaR1C1 = "=IF(OR(RC3="""",RC3=""Finish:""),"""",VLOOKUP(RC3,desc2,COLUMN(RC[-3]),FALSE))"
        
        Range("E2").AutoFill Destination:=Range("E2:J103"), Type:=xlFillDefault
    
    End Sub
    Is there another way to achieve the same result as below but in one step:

    Sub Macro1()
    
        Range("E2").FormulaR1C1 = "=IF(OR(RC3="""",RC3=""Finish:""),"""",VLOOKUP(RC3,desc2,COLUMN(RC[-3]),FALSE))"
        
        Range("E2").AutoFill Destination:=Range("E2:e103"), Type:=xlFillDefault
        Range("E2:E103").AutoFill Destination:=Range("E2:J103"), Type:=xlFillDefault
    End Sub
    Thanks in advance.
    Last edited by tone640; 08-17-2011 at 06:03 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