Re: Help with a Macro

Discussion in 'Microsoft Excel Setup' started by Gord Dibben, May 10, 2012.

  1. Gord Dibben

    Gord Dibben Guest

    Sub enter_one()
    With ActiveCell
    .Value = 1
    .Offset(1,0).Select
    End With
    End Sub

    But wouldn't it be just as easy to type 1 then ENTER?

    There must be more to this than what you describe.


    Gord

    On Thu, 10 May 2012 09:30:27 +0000, Helpmacro
    <> wrote:

    >
    >Hi,
    >
    >Currently looking for a simple macro that will type the number 1 and
    >shift down a cell and continue to do so each time the macro is pressed,
    >hoping this is possible sorry if it is not, relatively new to Excel and
    >macros.
    >
    >Thanks in advance.
     
    Gord Dibben, May 10, 2012
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Jason

    MACRO Help, how to prompt for printer?

    Jason, Jul 22, 2003, in forum: Microsoft Excel Setup
    Replies:
    0
    Views:
    558
    Jason
    Jul 22, 2003
  2. Matty

    Macro Help

    Matty, Jul 30, 2003, in forum: Microsoft Excel Setup
    Replies:
    0
    Views:
    525
    Matty
    Jul 30, 2003
  3. S Austin

    4.0 macro help file

    S Austin, Feb 24, 2004, in forum: Microsoft Excel Setup
    Replies:
    3
    Views:
    153
    Jim Cone
    Feb 25, 2004
  4. Guest
    Replies:
    3
    Views:
    323
    Guest
    Jan 13, 2006
  5. peter

    Help with a macro

    peter, Jan 22, 2006, in forum: Microsoft Excel Setup
    Replies:
    2
    Views:
    156
    peter
    Jan 23, 2006
Loading...

Share This Page