Use the following code to find the last data row in a worksheet.
Monday, 12 October 2015
FIND THE LAST COLUMN IN A WORKSHEET USING VBA
Use the following code to find the last data column in a worksheet.
IMPORT CSV OR ANY DELIMITED TEXT FILE WITH UNICODE ENCODINGS IN EXCEL USING VBA
This post demonstrates how to import CSV or any delimited text file with Unicode encoded in Excel using VBA code. By default, text files are encoded in ANSI representation on WINDOWS platform. When you try to import the ANSI encoded text files into excel using VBA, you may not see problems with the data appearing in the excel
Tuesday, 10 March 2015
Difference between print(null.toString()) and print(null)
This post demonstrates difference between print(null.tostring()) and print(null) in Java programming. The difference is print(null.tostring()) throws null pointer exception but print(null) doesn't. Why? Consider the below sample code to understand the concept clearly. public class NPETest { public static void main(String[] args) { Object obj1 = null; Object
Monday, 9 March 2015
System.out.println(null) ?
This post demonstrates why System.out.println(null) causes a compilation error and how to resolve. When you run the statement System.out.println(null), you will see the following compilation error. reference to println is ambiguous, both method println(char[]) in java.io.PrintStream and method println(java.lang.String) in java.io.PrintStream match Because there are (at least)
Friday, 6 March 2015
.png)
SIMD in .NET
Welcome to Logically Proven blog. This post demonstrates SIMD vector type. What is SIMD? SIMD stands for "Single Instruction, Multiple Data". It is a set of processor instructions that operate over vectors instead of scalars. This allows mathematical operations to execute over a set of values in parallel.
Thursday, 5 March 2015
ASP.Net vNext - A Completely New Version
This post demonstrates PROS and CONS of the ASP.Net vNext, a completely new version of ASP.Net. There is some super exciting stuff going on in the .NET community right now. I'm going to post a few entries on my favourites. ASP.Net vNext - This ASP version is so
Tuesday, 3 March 2015
How to suppress "Save Changes" prompt when the excel workbook is closed - VBA
Welcome to Logically Proven blog. This post demonstrates how to suppress "Save Changes" prompt when you close the excel workbook using VBA (Visual Basic for Applications). Note - This code works only when macros are enabled. Sometimes it is required to suppress "Save Changes" Prompt in your excel
Monday, 2 March 2015
Progress window with text updates in Excel - VBA
Welcome to Logically Proven blog. This post demonstrates how to create a progress window with text updates in Excel using VBA (Visual Basic for Applications). This post explains how to display the progress window with text updates as shown in the picture below - Consider the application user
Friday, 27 February 2015
Hide or Show an Excel Ribbon - VBA
This post demonstrates how to hide or show an excel ribbon using VBA (Visual Basic for Applications). In certain cases it may not required to show an excel ribbon to the user. In such cases, hide the excel ribbon for a better user interface. The excel ribbon
Thursday, 26 February 2015
Import CSV or delimited text file in Excel - VBA
This post demonstrates how to import CSV or any delimited text file in Excel using VBA code. Each line in the text file is written into one row in a worksheet. The imported data is separated into columns in a worksheet depending on the delimited character that you
Subscribe to:
Posts (Atom)
