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
Subscribe to:
Posts (Atom)
