Results 1 to 2 of 2

active.Cell compile error

Threaded View

  1. #1
    Registered User
    Join Date
    06-28-2011
    Location
    Stanford
    MS-Off Ver
    Excel 2010
    Posts
    2

    active.Cell compile error

    [SOLVED]

    This code results in "compile error: expected function or variable"
    Sub activeCell()
    '
    ' activeCell Macro
    '
    ' Keyboard Shortcut: Ctrl+m
    '
        Do
        activeCell.Activate
        activeCell.Offset(1, 0).Select
        Loop Until IsEmpty(activeCell.Offset(1, 0))
        
    End Sub
    I think something changed because another macro that worked an hour ago now returns the same error
    Last edited by forestPeterson; 06-28-2011 at 04:03 PM. Reason: Added Code tags

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