• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. V

    Want to filter >180

    Hi, I have a column with data as 0-30 31-60 61-90 91-180 >180. I am able to filter out all values using VBA but when it comes to ">180", I am not able to select that value as criteria in autofilter. Can somebody please help me in this !!!! Thank you.
  2. V

    Separating data entered using Alt+Enter in a cell

    Hi All, I want to separate out data tht was entered using Alt+enter. I have used TTC but the problem is that it does not give the desired output. With TTC, the data gets separated into different columns. I do not want that. I want to separate the data into single column but in different rows...
  3. V

    read files in zip folder one by one

    I have a zipped folder of excel files (around 16). I want to process these files using a macro one by one. I used the following code: Set folderPicker = Application.FileDialog(msoFileDialogFolderPicker) With folderPicker .AllowMultiSelect = False .ButtonName = "Pick Folder" .Show End With...
  4. V

    Reading excel Files without opening it

    Hi, i have huge data in the excels which i need to process. All the processing is done with the help of Macro,which is working fine. But it takes a lot of time for the macro to open the excel file (list of files) as the data is huge. Is there a way by which i can read the data in the workbook...
Back
Top