Latest news with #VBA
Geeky Gadgets
3 days ago
- Geeky Gadgets
Master Excel Automation : Save Hours with These Simple Tricks
Have you ever found yourself endlessly repeating the same tasks in Excel—formatting cells, applying formulas, or sorting data—wondering if there's a better way? You're not alone. Many Excel users spend hours on tedious processes that could be completed in seconds with the right tools. Here's the good news: you don't need to be a programmer to tap into Excel's automation capabilities. With features like macros and VBA (Visual Basic for Applications), you can transform your workflow, saving time and reducing errors, all without writing a single line of code—at least to start. Imagine the freedom of clicking a button and watching Excel do the heavy lifting for you. In the video below My Online Training Hub guides you through the essentials of Excel automation, from recording macros to understanding the basics of VBA. You'll discover how to record repetitive actions, create dynamic solutions, and even dip your toes into simple coding to unlock Excel's full potential. Whether you're looking to streamline data entry, build interactive dashboards, or automate formatting across multiple sheets, this guide will empower you to take control of your spreadsheets. By the end, you might just find yourself wondering how you ever managed without these tools. Let's reimagine what's possible with Excel. Excel Automation Basics What Are Macros? Macros are one of Excel's most versatile automation tools, allowing you to record a sequence of actions and replay them with a single click. For instance, if you frequently format datasets, apply filters, or sort tables, macros can handle these tasks in seconds, saving you significant time. To start using macros, you'll need to enable the Developer tab in Excel. This tab provides access to the tools required for recording and managing macros. Once enabled, you can record macros directly from the ribbon. Excel captures your actions step-by-step, creating a script that can be executed later. Macros are particularly useful for repetitive tasks, such as applying consistent formatting across multiple sheets or automating data entry processes. By recording your actions, Excel creates a reusable solution that eliminates the need for manual repetition. How to Record and Run Macros Recording a macro is a simple process that doesn't require any prior programming knowledge. Here's how you can do it: Open the Developer tab and start the macro recorder. and start the macro recorder. Perform the actions you want to automate, such as formatting cells, applying formulas, or creating charts. Stop the recorder once you've completed the steps. Excel saves these actions as a macro, which you can name for easy identification. Use clear and descriptive names, like 'FormatMonthlyReport,' to keep your macros organized. You can choose to store macros in the current workbook, a new workbook, or the Personal Macro Workbook, which makes them accessible across all Excel files. To run a macro, you can use the Developer tab, assign it to a button, or create a keyboard shortcut. This flexibility ensures that your automations are always accessible, regardless of your workflow. Automate Tasks in Excel Without Coding Skills in 2025 Watch this video on YouTube. Below are more guides on Excel Automation from our extensive range of articles. Getting Started with VBA While recording macros is a great starting point, learning VBA provides greater control and customization over your automations. VBA is the programming language behind Excel macros, allowing you to create more dynamic and complex solutions. You can access the Visual Basic Editor (VB Editor) from the Developer tab. This is where recorded macros are stored as VBA code. By exploring this code, you'll notice that each macro is written as a 'Sub' procedure, which defines a set of instructions for Excel to execute. For example, a simple VBA procedure might automatically highlight cells with specific values. By editing the code, you can modify the macro's behavior or create entirely new automations tailored to your specific needs. Key VBA Concepts to Know To effectively use VBA, it's essential to understand a few foundational concepts. These concepts form the building blocks of VBA programming and allow you to create more advanced automations: Objects, Properties, and Values: In Excel, everything is an object, such as a worksheet, cell, or chart. Each object has properties (e.g., font size, color) that can be modified by assigning values. In Excel, everything is an object, such as a worksheet, cell, or chart. Each object has properties (e.g., font size, color) that can be modified by assigning values. Variables: Variables are used to temporarily store data in your code. For example, you can store a user's input in a variable and apply it to multiple cells or calculations. Variables are used to temporarily store data in your code. For example, you can store a user's input in a variable and apply it to multiple cells or calculations. Loops: Loops allow you to repeat actions, such as processing every row in a dataset. This is particularly useful for automating tasks on large spreadsheets. Loops allow you to repeat actions, such as processing every row in a dataset. This is particularly useful for automating tasks on large spreadsheets. Conditional Logic: If-Then-Else statements enable decision-making in your code. For instance, you can check if a cell contains specific data before performing an action. By mastering these concepts, you can unlock the full potential of VBA and create automations that go beyond the capabilities of recorded macros. Advanced VBA Techniques Once you're comfortable with the basics, you can explore advanced VBA techniques to create more dynamic and interactive automations. These techniques allow you to build robust solutions that adapt to various scenarios: Message Boxes and Input Boxes: These tools enable user interaction. For example, you can prompt users to enter data, confirm actions, or display error messages. These tools enable user interaction. For example, you can prompt users to enter data, confirm actions, or display error messages. Error Handling: Adding error-handling routines ensures that your macros behave predictably, even when unexpected issues arise. This improves the reliability of your automations. Adding error-handling routines ensures that your macros behave predictably, even when unexpected issues arise. This improves the reliability of your automations. Dynamic Decision-Making: Use conditional logic to make your macros smarter. For instance, you can write a macro that checks whether a worksheet exists before creating a new one. These advanced techniques allow you to create flexible and user-friendly automations that can handle a wide range of tasks. Best Practices for Macros and VBA To maximize the effectiveness of your macros and VBA code, it's important to follow best practices. These guidelines will help you create efficient, maintainable, and secure automations: Save as Macro-Enabled Files: Always save your workbooks as macro-enabled files (XLSM) to ensure that your VBA code is preserved. Always save your workbooks as macro-enabled files (XLSM) to ensure that your VBA code is preserved. Comment Your Code: Add comments to your VBA code to explain its purpose and functionality. This makes it easier to understand and maintain, especially for others who may work on the file. Add comments to your VBA code to explain its purpose and functionality. This makes it easier to understand and maintain, especially for others who may work on the file. Use VBA Selectively: While VBA is powerful, it's not always the best solution. For tasks like data transformation, consider using Excel's built-in tools, such as Power Query, before resorting to VBA. By adhering to these practices, you can create automations that are both effective and easy to manage. Practical Applications of Excel Automation The applications of Excel automation are vast and can significantly enhance your productivity. Here are a few practical examples of how macros and VBA can be used: Invoice Generation: Automate the creation of invoices by generating unique invoice numbers and populating customer details automatically. Automate the creation of invoices by generating unique invoice numbers and populating customer details automatically. Data Filtering: Use input boxes to prompt users for specific criteria, such as a date range, and filter data accordingly. Use input boxes to prompt users for specific criteria, such as a date range, and filter data accordingly. Interactive Dashboards: Create dashboards that update dynamically based on user inputs, providing real-time insights. By using these techniques, you can reduce errors, improve consistency, and free up time for more strategic tasks, making Excel a more powerful tool in your workflow. Media Credit: MyOnlineTrainingHub Filed Under: Guides, Top News Latest Geeky Gadgets Deals Disclosure: Some of our articles include affiliate links. If you buy something through one of these links, Geeky Gadgets may earn an affiliate commission. Learn about our Disclosure Policy.
India Gazette
3 days ago
- Politics
- India Gazette
"Court was expected to provide information": Prakash Ambedkar slams Bombay HC judgement on validity of 2024 Maharashtra polls
Mumbai (Maharashtra) [India], June 26 (ANI): Vanchit Bahujan Aaghadi (VBA) chief Prakash Ambedkar on Thursday criticised the Bombay High Court's dismissal of a petition challenging the 2024 Maharashtra Assembly election results. He said that while the court has a duty to examine such matters, it appeared to have overlooked the concerns raised. The petition, backed by Ambedkar, alleged discrepancies in the voting process, including votes cast after the official deadline. Earlier, Bombay High Court dismissed Chetan Ahire's petition, alleging bogus voting in the 2024 Maharashtra Assembly elections. Addressing the media on Thursday, Ambedkar, who argued the case in the court, said, 'Chetan Ahire had filed an important issue regarding the conduct. It was about checking whether this election was free and fair or not.' He added that Ahire had filed a Right to Information (RTI) request and asked for data regarding the polls, but the RTI reply said that the information was not available. 'To get information whether it (election) was done according to the law, we had asked those in Delhi to file an RTI. The reply received from RTI was that the information we requested is not available. On the issue of 76 lakhs votes cast after 6 pm, which was also a question taken up by the Bombay HC, the VBA chief said, 'Once the time is up, if you want to vote, slips are distributed. According to the Election Commission's press note, 76 lakh votes were cast. Tell us whether those slips are available. The Election Commission has made a law; all this is binding. Did the polling officer give information?' On the petition filed in the court, he added that instead of considering it as a writ petition, the court took up the matter as an election petition and gave the verdict. 'So we did not get a (RTI) reply, then this petition was filed. The main point was that the legal obligations that require giving information... If the parties and the court are to give information to the election committee, there is a situation where this is a writ petition, but the court considered it an election petition and considering it as an election petition, they gave such a verdict,' he said. He further added, 'The Election Commission's press note was attached to the petition, and the Loksatta article was can we believe this news? It has no strength, the judge said.' 'There are reports that the voting done and the counting of votes do not match in 96 places. When asked through RTI, it was said that this information is not available. Whether it is in accordance with the law was asked, but there is no answer to this question in the judgment,' Ambedkar said. On the judgment, Ambedkar said, 'The court was expected to provide information, but unfortunately, the right to information will be obstructed by this. Examination is the duty of the court. But the court did not see it' He further said that two doubts arise here, that those who organised the election may have pressed the button to cast a vote or they may have received instructions from someone. 'This is not our personal dispute. If there is no document of voting after the time has expired, two doubts arise. Those who organised the election may have pressed the button, or they may have received instructions,' he said. The Bombay HC on Wednesday dismissed a petition that alleged bogus voting and had sought to set aside the results of the 2024 Maharashtra Assembly elections. A Division Bench comprising Justice GS Kulkarni and Justice Arif S Doctor rejected the petition filed by Mumbai resident Chetan Ahire, who had challenged the validity of the election results based on votes allegedly polled after the stipulated 6 pm deadline. Pronouncing its order after reserving it earlier this week, the court said: 'We have no manner of doubt that this writ petition needs to be summarily rejected. It is accordingly rejected. The hearing of this petition has practically taken the whole day, leaving aside our urgent cause list, and for such reason, the petition would certainly warrant dismissal with costs; however, we refrain from doing so.' (ANI)
Indian Express
4 days ago
- Politics
- Indian Express
Dalit protest against Imitiaz Jaleel in Chhatrapati Sambhajinagar puts spotlight back on AIMIM-VBA rift in Maharashtra
Despite the heavy rain in Maharashtra's Chhatrapati Sambhajinagar on Monday, a large group of Dalit protesters, many affiliated with Prakash Ambedkar's Vanchit Bahujan Aghadi (VBA) gathered at Kranti Chowk, demanding the arrest of former MP and All India Majlis-e-Ittehadul Muslimeen (AIMIM) Maharashtra president Imtiaz Jaleel. The protest followed an FIR filed against Jaleel on June 14 under the Scheduled Caste and Scheduled Tribe (Prevention of Atrocities) Act, based on allegations that he used a discriminatory slur against Shiv Sena minister Sanjay Shirsat. This protest symbolises a deep and now irreparable rift between the AIMIM and the VBA, two parties that once forged a rare alliance in the 2019 elections, seeking a convergence of the VBA's core Dalit vote base and Aurangabad's sizable Muslim population that together form nearly 29 per cent of the district. This convergence helped Jaleel get elected as the city's second-ever Muslim MP and the first from the community in over four decades. However, the alliance unravelled soon after Jaleel entered Parliament. The relations between the two parties have steadily deteriorated since, culminating in open hostility with the VBA now openly working to chart Jaleel's political downfall. What was Monday's protest about? Former Aurangabad MP and AIMIM leader Imtiaz Jaleel was booked earlier this month by the Aurangabad Police under the Scheduled Caste and Scheduled Tribe (Prevention of Atrocities) Act. The case stems from a recent press interaction in which Jaleel is alleged to have used a casteist term while criticising Maharashtra Social Justice Minister Sanjay Shirsat, whom he has repeatedly accused of corruption. While Jaleel has been targeting Shirsat for several weeks over alleged land and asset irregularities, Ambedkarite groups, particularly the VBA's leadership in Aurangabad, demanded his arrest, accusing him of making anti-Dalit remarks. Jaleel, however, has denied the allegations, calling the protest 'sponsored and politically motivated'. 'This protest was staged to shield a particular minister. It was entirely orchestrated by individuals claiming to represent the Scheduled Caste community. I have done nothing wrong. The term in question is not derogatory; it appears even in official publications printed by the Maharashtra government,' Jaleel said. What is the tiff between Jaleel and Shirsat? The rivalry between Jaleel and Shirsat has intensified ever since the latter was appointed guardian minister of Chhatrapati Sambhajinagar district in January 2025. Since then, Jaleel has repeatedly accused Shirsat of land misuse and abuse of ministerial power. The first major allegation came when Jaleel claimed that Shirsat's son, Siddhant, was illegally allotted a 21,275 sq m plot in the MIDC's Shendra Industrial Area in Chhatrapati Sambhajinagar. Jaleel had alleged that the land had originally been reserved for a truck terminus but was de-notified in August 2024. Jaleel alleged foul play and demanded a probe by central agencies such as the Enforcement Directorate (ED). Soon after, Jaleel also targeted Shirsat over the controversial auction of the VITS Hotel in Chhatrapati Sambhajinagar. After the hotel's original promoters declared bankruptcy, the state government seized the property under the Maharashtra Protection of Interest of Depositors (MPID) Act and began auction proceedings. A reserve price of Rs 64.53 crore was set, an amount that critics, including Jaleel, argued was grossly undervalued. In May 2025, a firm linked to Shirsat's son emerged as the highest bidder at Rs 67 crore. Alleging that the process was manipulated to benefit the minister's family, Jaleel and others demanded the auction be scrapped. The backlash eventually led to Shirsat's son withdrawing from the deal. To escalate pressure, Jaleel submitted documents related to Shirsat's land and business dealings to Ambadas Danve, Leader of the Opposition in the Legislative Council, and also urged Chief Minister Devendra Fadnavis to order an independent investigation. In retaliation, the Shirsat camp has accused Jaleel of being a political pawn, alleging that he is being used by rivals to discredit the minister. VBA leader Afsar Khan, a former ally-turned-critic of Jaleel, has accused him of using his political influence to purchase properties, including his current residence, at artificially low prices. Khan played a key role in Jaleel's narrow defeat in the 2024 Assembly elections, which he lost by just 2,161 votes. Why have VBA leaders targeted Jaleel? The rivalry between the VBA and Jaleel stems from a personal fallout dating back to their brief but impactful alliance in the 2019 Lok Sabha elections. While AIMIM had already made inroads in Maharashtra with two Assembly seats in 2014, the VBA was formed in 2018 under Prakash Ambedkar. In 2019, an alliance between Ambedkar and Asaduddin Owaisi brought together Dalit and Muslim voters. It was an experiment that proved successful in Chhatrapati Sambhajinagar, where Jaleel won a stunning upset over four-time Shiv Sena MP Chandrakant Khaire by a margin of just 4,492 votes. However, the partnership was fraught with friction even before the election. Ambedkar had initially announced former High Court judge B G Kolse Patil as the alliance candidate for Chhatrapati Sambhajinagar. But Jaleel, then a sitting MLA from Aurangabad Central, opposed the move and threatened rebellion from the AIMIM, stating that he would contest as an Independent. It was only after pressure from Jaleel that Owaisi stepped in, forcing Ambedkar to relent and allow Jaleel to contest the seat. After his victory, VBA leaders accused Jaleel of sidelining Ambedkar and failing to show due respect to the man they saw as instrumental in stitching the alliance together. The perceived snub created a deep personality rift, leading to a formal breakup between the VBA and AIMIM. Since then, Jaleel has been viewed by VBA leaders as the alliance-breaker. This animosity has continued to shape VBA's electoral strategy. The party has consistently fielded candidates against Jaleel, including in the 2024 Lok Sabha and Assembly elections, where Jaleel lost his Assembly bid by a narrow margin of 2,161 votes. While Ambedkar often avoids directly naming Jaleel in public, second-rung VBA leaders have openly criticised him, painting him as arrogant, disrespectful, and opportunistic. The ongoing feud between Jaleel and Shirsat has allowed Chhatrapati Sambhajinagar's VBA leaders to target Jaleel using the current controversy centred around caste-related allegations as a way to settle old scores with the man they believe 'betrayed their leader'.
Time of India
10-06-2025
- Politics
- Time of India
Bombay high court's Aurangabad bench hears Somnath Suryawanshi custodial death petition' Prakash Ambedkar seeks SIT probe
Chhatrapati Sambhajinagar: Vanchit Bahujan Aghadi (VBA) chief Prakash Ambedkar on Monday raised the demand for a court-monitored independent SIT to probe into Somnath Suryawanshi's death in judicial custody on Dec 16, 2024. Ambedkar raised the demand as the Aurangabad bench of the Bombay high court heard a petition filed by Vijayabai Suryawanshi, mother of Somnath Suryawanshi (35). Somnath was arrested in connection with the protests that had turned violent over the desecration of the Indian Constitution monument in Parbhani. Appearing for the family in the court, VBA chief Ambedkar, besides demanding a court-monitored independent Special Investigation Team (SIT), also spoke about the "lack of a clear legal mechanism" to take further action under Section 196 of BNSS. The matter was heard by the HC division bench of Justice Vibha Kankanwadi and Justice Sanjay Deshmukh. Following the SOP, a CID committee was appointed by the state govt to investigate the custodial death and prepared a report. However, the high court during one of the earlier hearings stayed the CID's proceedings before the report could be finalised. Chief govt pleader Amarjeetsingh Girase, who represented the state during the hearing, said, "During the course of Monday's hearing, we on behalf of the state submitted that the inquiry by the SIT was completed. We (SIT) recorded the statements of more than 190 people and collected all relevant documents as well as electronic evidence crucial for this case. As the HC during the last hearing directed us not to finalise anything, today we sought permission to submit the final inquiry report. " While Ambedkar, who was present along with a battery of lawyers, strongly pitched for directives to the state to address "the legal gap" in BNSS. "There is a void in the law about what should follow after a judicial magistrate conducts an inquiry in custodial death cases. We urged the HC to address this legal gap," he told the media after the hearing. "The second major demand was for the formation of a court-monitored SIT to conduct an independent investigation. "Since the custodial death occurred while Somnath was in judicial custody, it is inappropriate for the same police machinery to carry out the probe. The court heard our request positively. We are expecting an order on this soon," he added. Authorities had initially attributed Somnath's death to cardiac arrest. A postmortem report, however, indicated injuries consistent with physical assault. Chhatrapati Sambhajinagar: Vanchit Bahujan Aghadi (VBA) chief Prakash Ambedkar on Monday raised the demand for a court-monitored independent SIT to probe into Somnath Suryawanshi's death in judicial custody on Dec 16, 2024. Ambedkar raised the demand as the Aurangabad bench of the Bombay high court heard a petition filed by Vijayabai Suryawanshi, mother of Somnath Suryawanshi (35). Somnath was arrested in connection with the protests that had turned violent over the desecration of the Indian Constitution monument in Parbhani. Appearing for the family in the court, VBA chief Ambedkar, besides demanding a court-monitored independent Special Investigation Team (SIT), also spoke about the "lack of a clear legal mechanism" to take further action under Section 196 of BNSS. The matter was heard by the HC division bench of Justice Vibha Kankanwadi and Justice Sanjay Deshmukh. Following the SOP, a CID committee was appointed by the state govt to investigate the custodial death and prepared a report. However, the high court during one of the earlier hearings stayed the CID's proceedings before the report could be finalised. Chief govt pleader Amarjeetsingh Girase, who represented the state during the hearing, said, "During the course of Monday's hearing, we on behalf of the state submitted that the inquiry by the SIT was completed. We (SIT) recorded the statements of more than 190 people and collected all relevant documents as well as electronic evidence crucial for this case. As the HC during the last hearing directed us not to finalise anything, today we sought permission to submit the final inquiry report. " While Ambedkar, who was present along with a battery of lawyers, strongly pitched for directives to the state to address "the legal gap" in BNSS. "There is a void in the law about what should follow after a judicial magistrate conducts an inquiry in custodial death cases. We urged the HC to address this legal gap," he told the media after the hearing. "The second major demand was for the formation of a court-monitored SIT to conduct an independent investigation. "Since the custodial death occurred while Somnath was in judicial custody, it is inappropriate for the same police machinery to carry out the probe. The court heard our request positively. We are expecting an order on this soon," he added. Authorities had initially attributed Somnath's death to cardiac arrest. A postmortem report, however, indicated injuries consistent with physical assault.
Time of India
03-06-2025
- Health
- Time of India
15 Vanchit Bahujan Aghadi workers arrested for vandalising private hospital & threatening staff in Sangli
Kolhapur: A group of roughly 15 people associated with the Vanchit Bahujan Aghadi forcibly entered a private hospital in Sangli, and vandalised the property and assaulted staff members on Monday. The Sangli police have filed charges against the vandals and have arrested them. Aaditya Hospital, the medical facility that was targeted, is run by surgeon Sharad Sawant. The VBA workers claimed the hospital was charging fees from economically weak patients while simultaneously receiving govt compensation through the Mahatma Phule Jan Arogya Yojana. They also accused the hospital of providing substandard treatment to patients under the govt scheme. Sawant, however, rejected these accusations, claiming that certain local elements were attempting to force the hospital's closure. "We never charge a penny from the poor patients. There is a rule to initiate treatment or surgery only after approval from the govt machinery. There have been times when we did not wait for the approvals, given the condition of the patients. We challenge those accusing us to present the facts with documents, and we will also present the facts if they have any doubts. Vandalism, attacking the staff, and threatening us is not the way," said Sawant. Sawant alerted police when the vandalism commenced. Police intervened and detained the vandals. "We have arrested 15 people associated with a political party. We have invoked sections 3 and 4 of the Maharashtra Medicare Service Persons and Medicare Service Institutions (Prevention of Violence and Damage or Loss to Property) Act, 2010," said inspector Sudhir Bhalerao, of the Vishrambaug police station.
