+ Reply to Thread
Results 1 to 2 of 2

copy cell and paste diwn till last row

  1. #1
    Registered User
    Join Date
    06-21-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    39

    copy cell and paste diwn till last row

    Hi,

    I have recorded macro in which i want to copy cell f2 and paste till last row of coloumn F. in below code selected range showing "F2:F6" which i dont want as data in column F is not fixed.

    pls advise modification or short code in below :

    Range("F2").Select
    ActiveCell.FormulaR1C1 = "=RC[-1]*100"
    Range("F2").Select
    Selection.AutoFill Destination:=Range("F2:F6")
    Range("F2:F6").Select
    Columns("F:F").EntireColumn.AutoFit
    Selection.Copy
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
    :=False, Transpose:=False
    Application.CutCopyMode = False

  2. #2
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,551

    Re: copy cell and paste diwn till last row

    Try this

    Please Login or Register  to view this content.
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.

+ Reply to Thread

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