Results 1 to 9 of 9

Macro - input sheet selection

Threaded View

bobboy Macro - input sheet selection 02-19-2007, 03:46 PM
VBA Noob Hi, Do you mean you want... 02-19-2007, 03:52 PM
VBA Noob If that's what you meant then... 02-19-2007, 03:56 PM
bobboy Macro - input sheet selection 02-19-2007, 04:36 PM
VBA Noob Think you need to give more... 02-19-2007, 04:42 PM
bobboy Here is the Macro. Just need... 02-19-2007, 04:53 PM
VBA Noob Please wrap your code in... 02-19-2007, 05:20 PM
bobboy It's obvious I have little... 02-19-2007, 05:34 PM
VBA Noob There is a symbol on the... 02-19-2007, 05:42 PM
  1. #6
    Registered User
    Join Date
    01-29-2007
    Location
    Dobson, NC
    MS-Off Ver
    2000
    Posts
    24
    Here is the Macro. Just need it to enter on the sheet identified by C4

     
    Sub EnterData()
    '
    ' EnterData Macro
    ' Macro recorded 2/19/2007 by
    '
    ' Keyboard Shortcut: Ctrl+s
    '
        Range("E3:G3").Select
        Selection.Copy
        Sheets ("Sheet4")  
        Range("A7").Select
        Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
            False, Transpose:=False
        Rows("7:7").Select
        Application.CutCopyMode = False
        Selection.Insert Shift:=xlDown
        Rows("28:28").Select
        Selection.Delete Shift:=xlUp
        Sheets("Sheet1").Select
    End Sub
    Last edited by VBA Noob; 02-19-2007 at 05:19 PM.

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