
Originally Posted by
fixer
i need a simple code only one code that i will run and process done
i want only one code and it should done what i want is put all the details in one code like that
All macros are the same. They do the same thing.
Sub Makro1() is the same as Sub Vixer3a()
You do not need the two macros. You can use either ….
And here is another one
Code:
Sub Vixer3b() ' http://www.excelfox.com/forum/showthread.php/2353-add-by-vba?p=11425&viewfull=1#post11425
Workbooks.Open ThisWorkbook.Path & "\" & "1.xls"
ThisWorkbook.Activate ' If this workbook is active, then an unqualified range in a normal code module will revert to the active worksheet
Range("K9").Value = "=SUM('[1.xls]1-Sheet1'!$H$2:$H$121)"
Range("K9").Value = Range("K9").Value
Workbooks("1.xls").Close
End Sub
Sub Makro1() = Sub Vixer3a() = Sub Vixer3b()
I ( Alan ) prefer to make detailed codes. This is good for learning and this is good for teaching and this makes it easier to modify the coding later.
Using simple codes will waste everyone's time because you keep asking almost the same question every time. So soon no one will want to help you any more. That is what happened at Eileen's Lounge. ( https://www.eileenslounge.com/viewto...253802#p253804 )
मी तपशीलवार कोड बनविणे पसंत करतो. हे शिकण्यासाठी चांगले आहे आणि ते अध्यापनासाठी चांगले आहे आणि कोडिंग नंतर सुधारणे सोपे करते.
साधे कोड वापरल्याने प्रत्येकाचा वेळ वाया जाईल कारण आपणास वारंवार समान प्रश्न विचारला जातो. कोणीही लवकरच आपल्याला मदत करू इच्छित नाही कारण आपण शिकणार नाही. आपण शिकत नसल्यास आम्ही आपल्यासाठी कार्य करीत आहोत.
मध्ये Eileen's Lounge तेच घडले.. ( https://www.eileenslounge.com/viewto...253802#p253804 )
Alan
Bookmarks