Get VBA Code to Convert Excel to Xml Vba code in this page reads table data by each row and adds it to Xml dom element. Once all the cell values are added, it is then saved as Xml file. With this code you can also add Namespace to the […]
Find Local IP Address – VBA Macro Code
December 03, 2024
Computer IP Address – Local & Public IP stand for Internet Protocol address. It is assigned to every network device – be in a computer, smartphone, router etc., This address is used to send the Internet data packets to the correct device attached to internet. The IP address have different […]
Find Last Day of Month – Excel Formula & VBA
December 03, 2024
How to get Last day of Month? Excel has many option to find this End of Month. But in this page, We have given only the direct method. In Excel this formula can fetch you the End of month value. =EOMONTH(“2/12/2023”,0) – This will return the value as “2/28/2023”. This […]
Excel VBA Count #N/A Errors
December 03, 2024
How to count number of #N/A error in Excel? Number of occurrence of #N/A error in a column can be found by using the formula: Countif(<column>,”#N/A”) Consider, You havefew vlookup formula in column D. Out of it, few resulted in #N/A error. To get the count of this error in […]
Get Current Date in Vba
December 03, 2024
Display Today’s Date & Time in VBA Function used to displaz the current date / time is Vba.Now() This function will return the date & time in this default format: 7/14/2029 11:34:31 AM The returned output can be formatted into any desired format as given in the below code snippet. […]
Enable Cut/Copy/Insert/Delete Options in Excel Right Click
Enable Grayed Option on Excel Right Click Does some of the options on the right click command bar is disabled or grayed out in your Excel Worksheets. Though it is not very unsure for me why this happens often in my system, I could find out some workarounds to resolve […]
Fiverr Disabled – Issues with Freelancer Sites – My Experiences
December 03, 2024
Best Freelance Platforms As usual I signed up with lot of freelance websites like Upwork, Guru, Remote, Fiverr & Freelancer Out of all these, Fiverr worked out very well for more than a Year back in 2018. You can also make lot of money from these websites, just like how […]
Convert Number to String in Excel VBA Macro Code
VBA code to convert number to string. Convert variable of data type integer/float/double to a string value, so that the assignment or IF condition between different data type works fine.
Tata IPL 2022 Schedule PDF – Excel Match Time Table
Get IPL 2021 Dubai revised schedule PDF Free Download with Stadium details – IPL 14 Time Table, Online Ticket Booking, Venue details in table format. IPL Fixtures in Excel, PDF, Table, HTML format available.