Results 1 to 9 of 9

Simple Macro question

Threaded View

  1. #1
    Registered User
    Join Date
    10-17-2013
    Location
    Ny, NY
    MS-Off Ver
    Excel 2003
    Posts
    4

    Simple Macro question

    Hello, I am new to Macros. This should be simple. All I want to do is put an apostrophe in front of a five digit number. So i recorded a Macro, it is basically {F2}{HOME}{'}{ENTER}. I recorded it on the first number on the list which was 68410. The next number on the list is 67450; when I run the Macro, it changes the 67450 to 68410; not what I wanted - I only want an apostrophe in front of the 67450.

    I looked to edit the Macro, this is what it has, but I am unsure what to do:
    --------------------------------------------
    Sub Macro3()
    '
    ' Macro3 Macro
    ' edit a cell
    '
    ' Keyboard Shortcut: Ctrl+a
    '
        ActiveCell.FormulaR1C1 = "'68410"
        ActiveCell.Offset(1, 0).Range("A1").Select
    End Sub
    --------------------------------------------------
    thanks for any help! Mike
    Last edited by arlu1201; 10-17-2013 at 01:12 PM. Reason: Use code tags in future.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Problem running simple macro in Excel 2010
    By SuzieW in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-11-2012, 03:44 AM
  2. Simple Macro Question
    By sarahwilson1000 in forum Excel General
    Replies: 1
    Last Post: 06-23-2011, 04:51 PM
  3. a simple macro question
    By lotaguts in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-23-2007, 11:11 AM
  4. A Simple(?) Macro Question
    By DaveJones39 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-24-2006, 09:50 PM
  5. Macro question - I'm sure it's simple...
    By chrisgoulden in forum Excel General
    Replies: 3
    Last Post: 02-23-2006, 12:01 PM

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