Results 1 to 14 of 14

Macro recorded with errors in Excel VBA

Threaded View

  1. #1
    Registered User
    Join Date
    03-26-2008
    Posts
    44

    Macro recorded with errors in Excel VBA

    I am recording a macro to automatically generate the lines of code. After I start the macro and stopped recording, I check the code. Immediately, I receive a "Syntax Error".


    This was a recorded macro, why would it generate a wrong code?

    The code below is exactly how it was recorded.

    I have Excel 2016 in WindoWs 10.

    Thank you
    
    Sub FixFilter()
    '
    ' FixFilter Macro
    '
    
    '
    Range("A1").Select
    ActiveSheet(, .(xlToRight)).Select
    ActiveSheet(, .(xlDown)).Select
    .
    ActiveSheet.Enabled  := 10
    .ActiveSheet("$A$1:$T$841"). Index := 20, BringToFront := "<>"
    Range("R545").Select
    End Sub
    Last edited by gtg430i; 02-24-2019 at 12:08 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Simple Excel Recorded Macro Has Syntax Errors
    By MotorCityCanuck in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-12-2018, 04:54 PM
  2. Recorded Macro Errors...
    By Will03 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-03-2014, 02:48 PM
  3. [SOLVED] Need to take off Recorded Macro which minimizes the Excel program
    By cesarmontoya in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-19-2013, 02:30 PM
  4. [SOLVED] Recorded Pivot Table Macro Doesn't Do What I Recorded!
    By diakonos1984 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-26-2013, 11:01 AM
  5. [SOLVED] excel 2007 chart macro graphs data only from sheet on which macro was recorded
    By JW1028 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-19-2013, 06:33 PM
  6. Recorded macro that creates buttons errors when I run it
    By cklein in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-09-2012, 06:24 PM
  7. Excel VBA error-recorded a macro to sort
    By Leena in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-13-2005, 11:06 AM

Tags for this Thread

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