Results 1 to 3 of 3

Trouble Pasting

Threaded View

  1. #1
    Registered User
    Join Date
    10-15-2012
    Location
    Palm Springs
    MS-Off Ver
    Excel 2002
    Posts
    2

    Trouble Pasting

    There is data is columns A:C. I can't paste my selected calc with the following.... Your help would be greatly appreciated. Thanks

    Sub aaaa()
    Dim lw As Long
        Range("D1").Select
        ActiveCell.FormulaR1C1 = "=R[1]C[-2]-RC[-2]"
        Range("D1:D2").Select 'D2 is blank. I need the calc in D1 to be copied to every other cell in the range
        Selection.Copy
        lw = Range("A" & Rows.Count).End(xlUp).Row 'Select cells in column D only if there is data in A
        Range("D1:D" & lw).Select
        ActiveSheet.Paste 'I lose the ability to paste D1:D2 to the selected range.
    '   I can copy the selection to D:D, but I get 65,000 rows I don't want.
        Application.CutCopyMode = False
    End Sub
    Last edited by jeffreybrown; 10-15-2012 at 08:35 PM. Reason: Added code tags for new user. Please do so next time...Thanks.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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