excel vba 2016

  1. S

    Excel VBA to extract 2 or 3 keywords left and right from cell content

    Hi Friends, Trying to extract 2 or 3 keywords from cell content through excel vba. Sheet1 ColumnA has rows with content sample file attached. I need vba to search for keywords from sheet2 ColumnA in Sheet1 and extract 2 or 3 or 4 keywords from each row content into sheet3.(Popup box would be...
  2. D

    Check if sheet exists while looping through workbooks

    Hi all, can anyone help me call this function? I found this function to check if a sheet exists but I dont know how to call it. The macro looks at a folder and opens every excel workbook in it, extracting data. I am adding the fucntion for the eventuality that the user point the folderpicker...
  3. D

    Creating sheets from filter. How to modify to start from row 2.

    Hello all, Can decipher this impenetrable code sufficiently to make it ignore the first row on the sheet on which it runs? I am changing the sheet so that the control buttons take up row one. This sub is called from a larger sub that also changes the button settings so that they are...
  4. D

    Help with an Excel VBA Autofilter copy paste syntax problem anyone?

    Hi folks, I am a bit syuck on the auto-filter syntax. can anyone tell me how to change this so that I am not copying and pasting the whole row, but only copying range "A" to "L" to usdrws and pasting into range "B" to "M", (same rows as below). ws.AutoFilter.Range.Offset(1).EntireRow.Copy...
  5. D

    Microsoft Print to PDF Suppress "printing" Dialogue

    Hi, I wonder if anyone knows how to do this? I would really appreciate some help. I did find something i think is the answer but it is very old and i have no idea how to use it. I have a macro that runs through an excel sheet, reads an address of otehr workbooks from hyperlinks in column A...
  6. S

    Run-time error 3343 - Is there a solution

    I have the following code but have not found a solution online. Has anyone figured out a solution? or would this relate to an authentication issue from my company's server? how do I get around that? I have the following references: Microsoft Access 16.0 Object Library Microsoft DAO 3.6...
  7. D

    Find and Replace any characters in a list of characters

    Hi, i could really use some help with this. i have this code that checks a column for an illegal character (for sheet name) and replaces it with "_". I want it to check for the fill list of characters that are not allowable sheet names .Pattern = "[\<\>\*\\\/\?|]" Sub...
  8. D

    Error '1004' Sort method of range class failed

    Can anyone figure out why this fails? I have done everything i can think of to make sure there is nothing to bother it. I have run it with the header cleared, I have deleted all rows with any illegal characters. Ii have added a little sub to do this too. I am using a script i that creates...
  9. D

    VBA Creating Named Tables in multiple sheets in new workbook

    Hi, i have some code that a) filters data from the table in one sheet into a group of new sheets named by the filter value b) creates a new workbook from these sheets The script does the above. The additional code has no effect that i can see. It doesnt stop it working, it just doesnt do...
  10. D

    VBA Subtotals one filter criteria from another column

    I have expenses sheets where various columns of figures need to be totalled according to the filter criteria in the costs centre column. I had been trying the subtotal 9/109 function expecting that to work, but it seems you can only subtotal if the column is filtered on its own values. The...
  11. D

    vba Export Excel to PDF. 2 pages. One Portrait, One landscape.

    Hello, if anyone knows how to do this, I would appreciate a pointer. There are a few threads on it but i havent found one that actually answers the question of how to do it as one PDF with different orientations per page. This is where i am at so far... Sub ExportPDF2() Dim sFile As String...
  12. D

    Return multiple data from excel sheet using vba

    Good day all, Please, I have a slight problem. I created a userform with 40 textboxes that submits its contents to sheet1. The userform generates a time stamp in a label (label2) using Format(Now(), "H:MM"). When I click the submit button upon filling the form, each filled textbox is...
  13. D

    VBA Copy whole rows based on find hits

    Hi, could really use some help with this. (hopefully not as dumb as question as last time! I am trying to write a macro that will search through a load of sheets for a value in column L, and if it finds that value, copy the whole row (and repeat for all non blank rows in sheet) I will need to...
  14. T

    Runtime Error 13 problem

    I am working on a simple spreadsheet that changes characters when you click on the cell, then counts the cells that are of a certain character. I have set the range to only look at certain cells (A3:A27, B3:B27) but anytime I click on row 1 (Row with several merged cells) or select multiple...
  15. J

    Sorting macro skips the first row and begins sorting the second

    A simple sort routine is being used across a number of reports, but there's a few instances where the sort begins on the second row (row 13) and the not the first (row 12). It's strange, because the same code works fine in the majority of cases. Any ideas? Thanks in advance...
  16. O

    Retrieve date from MsgBox to TextBox in other Form

    Hello, I got stuck on the following code that shows date selected from datepicker Private Sub select_label(msForm_C As MSForms.Control) '/* Capture the selected date */ Dim i As Integer, sel_date As Date i = Split(msForm_C.Name, "_")(1) - 1 sel_date = FirstCalSun(curMonth) + i...
  17. S

    Extracting Autosuggestions from Wikipedia after entering keyword in Search with Excel vba

    Hi Friends, I have list of keywords in Sheet2AColumn like PHP A PHP B PHP C and so on. I need VBA to search keyphrase("PHP A") from Sheet2AColumn in search box and extract all autosuggestion urls into sheet1AColumn. I did search in forum posts here, but did not find a VBA code which does the task.
  18. S

    How to extract en.wikipedia.org first paragraph into excel with VBA

    Hi Friends, Been through some of the posts related to wikipedia.org to extract data into excel. But did not find exact match to my need. I am looking to extract first paragraph of en.wikipedia.org article into excel sheet using VBA. Here is sample links I am trying to. I have huge list of...
  19. W

    Excel VBA Help

    Hi all i am new to Excel VBA and i need help in coming up with a macro to carry out a time consuming task. This is what i want the Macro to do when the Update data button is clicked: It should copy the information from certain columns (A,B and F for example) of worksheet 1 and "paste special"...
  20. J

    ActiveWorkbook.Queries.Add Filter Criteria

    Hello, I have a code in which i use ActiveWorkbook.Queries.Add to import a CSV file. But while importing i need to filter only those rows containing value given by user. Below is the code. I have Highlighted and Bold the portion where i give the filter criteria as [Object ID] = 140. But what i...

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top