If you want get or print file names from a certain directory, then you can use following code. Sub GetFileNames() Dim sPath As String, sFileNm As String sPath = “C:\DW\” ‘You can also use Application.GetOpenFilename to get a file name from a folder, ‘and then extract the Directory name from that string ‘You can also […]
Continue readingProblem Are you frustrated that you have to concatenate a big range of cells in Excel, but you have to do so using CONCATENATE function by entering each cell and typing a comma after every cell? Well, here’s a solution to it. A procedure or a function whatever you like. If you use the procedure, […]
Continue readingIf you want to do a text search count in a range, you can use the following formulas:Where D3 is the search text and the range A2:A16 houses the data. An array formula using SUM and SEARCH {=SUM(IF(ISERROR(SEARCH(D3,A2:A16)),0,1))} Another using COUNTIF: =COUNTIF(A2:A16,”*”&D3&”*”) This picture might make it clear:
Continue readingYou cannot change the default Row (1,2,3,…) and Column (A,B,C,D….) headers, but you can give your spreadsheet the look and feel as if you had custom headings. Solution Enter what you’d like to be your Row Headers in the first column leaving cell A1 blank Enter what you’d like to be your Column Headers in […]
Continue readingIn this short video you can learn how to assign a macro to a button on your toolbar. If this macro is in the personal workbook then you can use it on any workbook.
Continue reading