1. L

    Multiple subs in VBA Code ?

    Good morning. I am working on the same spreadsheet described in this thread (https://www.mrexcel.com/forum/excel-questions/1112241-hiding-rows-using-vba-multiple-criteria.html) It is a sheet where based on the answers provided in a set of dropdown boxes, certain rows need to be hidden...
  2. tlc53

    VBA Code - Closing Statement Wrong Perhaps

    Hi, I have the below code which is returning an error, I believe near the bottom. It says I need to "End With" but when I put "End With" before "End Sub" it says it wasn't expecting "End With" :banghead: I'd really like this to run without any problems. Can someone please show me where I am...
  3. D

    Filter Macro where cell contains

    Hi there, I have a sheet with 1500 records I'm trying to match to another sheet that has 700 records. The company name is not an exact match, so VLOOKUP is not an option. I built a tool with a macro for an advanced filter, and one to clear the data. The problem is that my filter is only looking...
  4. B

    VBA Search for any of three items, return whole row or rows of matching data.

    <colgroup><col span="2"><col><col><col><col span="2"><col><col><col><col><col><col><col><col></colgroup><tbody> I recently added a search button to my userform, But it does not seem to search. I am trying to use existing Text Boxs for searching by either Customer...
  5. M

    VBA Copy from Closed Workbook

    Hello Everyone, I have a small problem with copying sheets from closed workbook "x" to my workbook "y". So the copying isn't the problem, just the formulas in workbook "x" because in this workbook I have formulash which referres to another sheet in this workbook. So when I am coping this sheet...
  6. P

    Auto-Save issue

    Hello, I have an issue with my auto-save macro on every 2minutes. It was working ok for couple of days, but now it is behaving odd. Macro is as follows (in Module1): Public dTime As DateSub MyMacro() Dim fPath As String Application.DisplayAlerts = False dTime = Now + TimeValue("00:02:00")...
  7. L

    Hiding Rows using VBA with multiple criteria

    I apologize if the title of this post is confusing. I have an Excel sheet that can have up to 10 entries. I have a drop down in AA3 with #'s 1-10. Based on the selection in that box, I need a certain number of rows to be hidden. If 1 is selected, I need a certain set of rows, if 2 is...
  8. TAPS_MikeDion

    Can you change a button group lock options to True/False with 1 command?

    Just wondering if I can shorten my code a tad by changing grouped buttons with 1 command instead of two. For example: If you have a group of two radio buttons (for this example I'll call the group "NewEmp") and you want to lock or unlock them, do you have to use two commands (i.e...
  9. H

    Combination of 1/0 with TRUE/FALSE

    Column B2:B7 is EITHER of 1 OR 0 Input Data Range D2:H7 is EITHER of TRUE OR FALSE Input ‘Header’ (above D2:H7) i.e. D1:H1 is 111, 222, 333, 444 & 555 Output Range J2:N7 as shown: How to accomplish. Thanks in advance I am using Excel 2007 Sheet2 <colgroup><col style="FONT-WEIGHT: bold...
  10. L

    Hide Tab Based Upon Cell Value

    Hello All! I was attempting to have a tab hidden based upon 'yes' or 'no' value placed into the cell of another tab. I have included my macro below (see very end for my issue) which is not working. :( Any recommendations appreciated! Thanks! Private Sub Worksheet_Change(ByVal Target As...
  11. L

    Hide Column on Another Sheet

    Hello All, I have the macro below that I was hoping to get some assistance on. Macro was working fine until I tried to both hide/unhide rows on the current worksheet and hide/unhide column on another worksheet based on response given in cell C24. Feel like it is something simple with the end...
  12. L


    Hi Why this formula is giving me 0 =IF(E2>50, ,) I thought it should give me True if E2 > 50 and False if E2 < 50 because I did not specify what would be if the condition is True or False. Thank you very much.
  13. L

    VBA Slow Copy Paste from Csv - Faster way to import? [Current Code Included]

    Hello, I have a VBA report I wrote. The report starts by Opening 2x CSV files Goal.csv (18MB) and Objective.csv (40MB) and copying their sheet contents to corresponding sheets in the report. The fastest now I can get the report to open is about 1 min. The open,copy, and paste process is taking...
  14. K

    vba filtering with multiple values

    Hi, I am trying to filter pivot fields and datasets through user input with multiple filters. Pivot filters works fine in isolation. I have tried different variations and could not find a solution how to make them work together. Dataset can not be filtered with 3 criterias, and I could not...
  15. M

    VBA Disabling 'Saving As' Popup

    How do I disable the popup that says Excel is "SAVING AS" with the bar that shows % complete? Application.DisplayAlerts = False doesn't seem to help. Application.DisplayAlerts = False ThisWorkbook.Save txtdate = Format(Now, "mm") & "." & Format(Now, "dd") & "." & Format(Now, "yy")...
  16. C

    How to speedup VBA

    Hi, I used to transfer invoice data to another workbook [data], sheet "sales" and sheet"csales also add new workbook invoice sheet with below code, it took 3 second to complete. is there is way to speed up this process. Sub SavingSalesData() Application.ScreenUpdating = False...
  17. G

    Help with Userform MsgBox

    Hi everyone, I have a userform that has 2 textboxes to add data to a worksheet, this all works fine although i would like it to also search a worksheet called "Members" for a matching value entered into my first textbox called "txtMemFirst" if no matching name is found then it needs to show a...
  18. D

    Transposing group of cells in column to rows

    I copy the following from a web page that was 4 column of rows. I pasted it in excel and showed up in one column. 9/26/2019 11:15 BTC 0.03142971 Completed 9/19/2019 12:01 BTC 0.02388444 Completed 9/10/2019 20:46 RVN 2414.582 Completed There are more than 100 of these groups in one column. I...
  19. N

    Quick VBA Help

    Below is the code I have now. I need it to be With Sheets("Cash Update Data") .Range("O1").AutoFilter 15, "12" Everything not including "#N/A" .AutoFilter.Range.Offset(1).EntireRow.Copy Sheets("QTD").Range("A2") QTD is in another workbook .AutoFilterMode = False End...
  20. K

    Help with VBA code to filter, copy and paste in another worksheet

    I need some help with the code below. On my "Leases" worksheet I have data in columns A through F. I am filtering on the word "Question" in column F then coping those rows into the first available row on my "Question" work sheet columns A through F. The code works fine provided the word...

Some videos you may like

This Week's Hot Topics