Results 1 to 2 of 2

Thread:

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User
    Join Date: Sep:2009
    Location: Sofia
    Posts: 12

    . , 26 . -. .

    Sub Macro4()
    '
    ' Macro4 Macro
    ' Macro recorded 22.5.2010
    '
    ' Keyboard Shortcut: Ctrl + q
    '
    ActiveCell.Rows("1:1").EntireRow.Select
    Selection.Insert Shift:=xlDown
    ActiveCell.Offset(0, 6).Range("A1").Select
    ActiveCell.FormulaR1C1 = "=TODAY()"
    ActiveCell.Offset(1, 0).Range("A1").Select
    End Sub

  2. #2
    It's not Jim Beam! XcArm's Avatar
    Join Date: Aug:2008
    Location:
    Posts: 118
    . .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |