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
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

5 Replies

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"

@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.

@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.

 

@Charla74 

Gracias! Espero alguien que sepa lo vea y me diga

Buen dia a todos

 

Me encuentro en la misma situacion que @JorgeMejia, alguien supo solucionar este error? O quedo en el olvido por completo jajajaj

 

Gracias 

 

Saludos