Results 1 to 1 of 1

problem with how if insert copy paste working steps of macros when using VBA code

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-11-2009
    Location
    Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    252

    problem with how if insert copy paste working steps of macros when using VBA code

    hello ,

    I was recording a macro like this:
    Sub Macro3()
        Selection.EntireRow.Insert , CopyOrigin:=xlFormatFromLeftOrAbove
        Range("E3").Select
        Selection.Copy
        Range("C4").Select
        Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
            :=False, Transpose:=False
        Range("E4").Select
        Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
            SkipBlanks:=False, Transpose:=False
        Range("D3").Select
        Application.CutCopyMode = False
        Selection.Copy
        Range("C3").Select
        Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
            :=False, Transpose:=False
    End Sub
    what if it is using VBA code,is it possible..? because the macro is only valid for a particular cell


    thanks in advance
    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