Results 1 to 10 of 26

Thread: Misc. Leonardo1234 rider@1234 vixer. Highlighting. Simple Early stuff. Avinash Introduction

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #11
    Fuhrer, Vierte Reich DocAElstein's Avatar
    Join Date
    Aug 2014
    Posts
    10,457
    Rep Power
    10
    Quote Originally Posted by fixer View Post
    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
    Last edited by DocAElstein; 08-18-2019 at 04:08 PM.

Similar Threads

  1. Class Stuff: VBA Custom Classes & Objects, Class Modules
    By DocAElstein in forum Excel and VBA Tips and Tricks
    Replies: 29
    Last Post: 06-02-2024, 01:49 PM
  2. Replies: 9
    Last Post: 05-13-2021, 02:31 PM
  3. Replies: 2
    Last Post: 06-23-2019, 03:30 PM
  4. VBA Range.Sort with arrays. Alternative for simple use.
    By DocAElstein in forum Excel and VBA Tips and Tricks
    Replies: 24
    Last Post: 04-22-2019, 12:31 PM
  5. Free And Simple Excel Based Gantt Chart
    By Excel Fox in forum Download Center
    Replies: 0
    Last Post: 05-02-2013, 03:16 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •