Error de grabacion de macros

%3CLINGO-SUB%20id%3D%22lingo-sub-1434488%22%20slang%3D%22es-ES%22%3EMacro%20recording%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1434488%22%20slang%3D%22es-ES%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Error%202.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F195995i6AB2B55319607AD4%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Error%202.PNG%22%20alt%3D%222.PNG%20Error%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EHello%2C%20good%20day!%2C%20what%20I%20did%20in%20Excel%20was%20record%20a%20macro%20and%20the%20actions%20I%20did%20was%20put%20in%20certain%20cells%20some%20name%20and%20one%20time%20I%20stopped%20this%20I%20stopped%20recording.%20And%20I%20appeared%20this%20syntax%20error%20always%20appears%20to%20me%20every%20time%20I%20record%20a%20macro%20no%20matter%20what%20action%20I%20perform%2C%20it%20only%20works%20for%20me%20if%20I%20put%20the%20code.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20someone%20can%20help%20me.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1434488%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1434544%22%20slang%3D%22en-US%22%3ERe%3A%20Error%20de%20grabacion%20de%20macros%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1434544%22%20slang%3D%22en-US%22%3E%3CP%3ENot%20sure%20why%20the%20macro%20recorder%20would%20include%20'.Start'%20in%20each%20line.....It%20looks%20like%20it%20has%20replaced%20what%20would%20normally%20be%20entered%20as%20'.Select'.%26nbsp%3B%20The%20following%20should%20work%20in%20place%20of%20the%20first%20few%20lines%20of%20code%3A%3CBR%20%2F%3E%3CBR%20%2F%3ERange(%22A3%22)%20%3D%20%22Region%22%3CBR%20%2F%3ERange(%22B3%22)%20%3D%20%22Expense%22%3CBR%20%2F%3ERange(%22C3%22)%20%3D%20%22Jan%22%3CBR%20%2F%3ERange(%22D3%22)%20%3D%20%22Feb%22%3CBR%20%2F%3ERange(%22E3%22)%20%3D%20%22Mar%22%3CBR%20%2F%3ERange(%22F3%22)%20%3D%20%22Total%22%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1434560%22%20slang%3D%22es-ES%22%3ERe%3A%20Macro%20recording%20failed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1434560%22%20slang%3D%22es-ES%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F531239%22%20target%3D%22_blank%22%3E%40Charla74%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much!%2C%20I%20still%20do%20not%20know%20why%20when%20I%20record%20the%20macro%20changes%20all%20the%20code%2C%20already%20try%20contacting%20Microsoft%20but%20I%20did%20not%20solve%20anything%20just%20said%20to%20wait%20for%20someone%20to%20answer%20me%20around%20here!%20I%20thank%20you%20again.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1434591%22%20slang%3D%22en-US%22%3ERe%3A%20Error%20de%20grabacion%20de%20macros%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1434591%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F685968%22%20target%3D%22_blank%22%3E%40JorgeMejia%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20quite%20strange%20and%20I've%20not%20seen%20this%20before%20or%20can%20find%20anything%20like%20it%20online.%26nbsp%3B%20%26nbsp%3BSorry%20I%20can't%20help%20more.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1434617%22%20slang%3D%22es-ES%22%3ERe%3A%20Macro%20recording%20failed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1434617%22%20slang%3D%22es-ES%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F531239%22%20target%3D%22_blank%22%3E%40Charla74%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%20I%20hope%20someone%20who%20knows%20what%20he%20knows%20and%20tells%20me%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Error 2.PNG

Hola, buen día!, lo que hice en Excel fue grabar una macro y las acciones que hice fue poner en ciertas celdas algún nombre y unas vez terminado esto detuve la grabación. Y me apareció este error de sintaxis siempre me aparece cada vez que grabo una macro no importa la acción que realice, solamente me funciona si yo pongo el código. 

 

Espero alguien me pueda ayudar. 

 

Gracias

4 Replies
Highlighted

Not sure why the macro recorder would include '.Start' in each line.....It looks like it has replaced what would normally be entered as '.Select'.  The following should work in place of the first few lines of code:

Range("A3") = "Region"
Range("B3") = "Expense"
Range("C3") = "Jan"
Range("D3") = "Feb"
Range("E3") = "Mar"
Range("F3") = "Total"

Highlighted

@Charla74 

Muchas gracias!, igualmente no se porque razón cuando grabo la macro me cambia todo el código, ya intente contactando a Microsoft pero no me resolvieron nada solo dijeron que esperara a que alguien me contestara por aquí! Te agradezco nuevamente.

Highlighted

@JorgeMejia 

 

It's quite strange and I've not seen this before or can find anything like it online.   Sorry I can't help more.

 

Highlighted

@Charla74 

Gracias! Espero alguien que sepa lo vea y me diga