Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Error Result in recording a Macro in Excel VBA
No the other recordings si the same and here is another code after recording: i am typing Number (1) and then coloring it by red with filling by yellow color. Sub Macro1() ' ' Macro1 Macro ' ' ActiveCell FormulaR1C1 <= VB_VarUserMemId1VB_VarUserMemId Range&...- mohengciv
- Post #7
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Error Result in recording a Macro in Excel VBA
Dear Tony I don't use anything of you mentioned but i just recorded this macro then it came like this on the other hand when i recoed another one in word it comes good as i expect. any body help me.- mohengciv
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Error Result in recording a Macro in Excel VBA
this is a code to make borders to a cell: Selection+Borders&xlDiagonalDown'+LineStyle <= xlNone Selection+Borders&xlDiagonalUp'+LineStyle <= xlNone Wend Selection+Borders&xlEdgeLeft' +LineStyle <= xlContinuous +ColorIndex <= 0 +TintAndShade <= 0 +Weight...- mohengciv
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Error Result in recording a Macro in Excel VBA
Dear All please help me in my problem. after i finish recording a macro in excel i find the code in visual basic editor doesn't look like vba code it seems like C++ code. kindly help me.- mohengciv
- Thread
- Replies: 8
- Forum: VBA Visual Basic for Applications (Microsoft)
