modify

  1. M

    VBA autofilter - filter blanks only

    Hi I've recorded a macro which filters blanks in a sheet. However, I need to modify it, so that it deletes the blanks from the range in the sheet regardless of the number of rows. Does anyone know how to modify the code below, please? Also, is there a good tutorial on VBA autofilters that...
  2. gheyman

    Access: VBA to identify User and rights

    I have code that checks a table to see if the Current User should be able to open a form Private Sub Form_Open(Cancel As Integer) On Error GoTo Error_Handler If Nz(DLookup("UserName", "tbl_Users", _ "[Object_Name]='" & Me.Name & "' AND [UserName]='" & CurrentUser()...
  3. C

    If statement

    Good morning everyone, I hope someone can helps with this one, I have the following formula(copied down through rows etc) =IF(D2=G2,"ok",IF(D2>G2,"Supplier MPQ higher","Check pack multiple")) to return a simple text answer, but what I wish to modify this (if possible) to show that t if G2 is...
  4. D

    Modifying a (sum, indirect, substitute, address, column), formula?

    <colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>#DAE7F5[/URL] "] A B C D E F G H I J K L M N O P Q R S T U V W X...
  5. leopardhawk

    Need help with complicated IF statement, possible IFS?

    I have a worksheet that will most likely be used by two people (a couple) but could also be used by a 'single' (unmarried) individual. I'll try to explain my conundrum. Here goes... The worksheet contains a cell with the following formula and it works as intended but I would like to modify it...
  6. detweiler

    Macro to hide rows ad hoc

    I found this - - Worksheets(“Sheet1”).Range(“RowNumber1:RowNumber2”).EntireRow.Hidden = True - - and would work, but would have to modify it each time based on the worksheet I'm in. Yes, right-clicking is easy, but when there are hundreds or, and a couple of times, thousands, no so much. Is it...
  7. A

    Problem incrementing GetPivotData formula

    Hello everyone I have a GETPIVOT Data formula in A8 =GETPIVOTDATA("[Measures].[Name]",Total!$A$1,"[ValuesTable].[Employee ID]","[ValuesTable].[Employee ID].&[A0107733814033]") But this doesn't increment because of the ID written so i've tried to modify it to...
  8. J

    Question About Posting Questions Posted on Other Forums

    Hi everyone, can i post a thread present in another forum? jc
  9. B

    doble click to modify selected record in listbox and right click to delete

    hello i like to have help with vba codes : i have a listbox in userform4 i like to add a code to use right click to modify record using userform1 (userfrom1 is used to add new data to list) and to do right click on mouse to delete selected record from list please see file and original post...
  10. J

    Index formula

    Hi, i have this table and this formula, =INDEX(Sheet1!D2:D4,MATCH(Sheet1!C2,Sheet1!C2:C4,0)*MATCH(Sheet1!A2,Sheet1!A2:A4,0)) <tbody> ID DESC A/C # AMT 133888 VOICE 8883 545 100300 IP 9833 800 100358 INTERNET #N/A </tbody> how can modify it that if a/c # is blank still get the amount...
  11. P

    request for help, modify the macro to the values 3333333 = 7

    request for help, modify the macro to the values 3333333 = 7 so the example macrode below is at 444444 ie 6 boxes, the request is to modify for seven houses up to 3 then it will be 0000000- 3333333 = 7 positions 0000000 0000001 0000002 0000003 0000011 ...... 3333333 cannot have...
  12. M

    Modify code for vlookup

    I have a code that loads a value into 2 text boxes when you choose a part # in t lit box. I would like to modify the code so that it sees the part #in the list box and loads the text box, instead of upon selection of the part #. Can someone shoe me how to make the modification? Private Sub...
  13. rhino4eva

    find and delete again

    Sheets("Sheet1").UsedRange Dim Rng1 As Range For Each Rng1 In Range("Z:Z").SpecialCells(xlBlanks).Areas Intersect(Rng1.EntireRow, Range("A:BT")).Delete shift:=xlUp Next Rng1 ok so I have used this code many times but need to modify it a little...
  14. N

    Restrict Sheet Use to Certain Columns of Table

    I am using this code which works fine to restrict selection of one cell in a sheet. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Target.Range("A1").Select Application.CutCopyMode = False End Sub However, I need to modify this so that the restriction only applies to...
  15. T

    Modify VBA Code for Specific Sheet

    I have the following code in Thisworkbook in the VBA module. I would like to copy this code onto a specific sheet but not sure how to modify it. I think I would need to change the third line to the name of the sheet. Private Sub Workbook_Open() Dim sh As Worksheet For Each sh In...
  16. muhammad susanto

    Change And With Or in Complicated Function Maybe

    hi all.. i have following problem to modify this formula...
  17. R

    Need one more element to this formula

    How do I modify this: =IFERROR(VLOOKUP($A8,'D:\Corporate\Analytics\2019Analytics\Final2019\[NewsLettersJan2019.xlsx]Stations'!$A$3:$FC$156,64,FALSE),"") so the result is multiplied by J6 thank you in advance
  18. P

    Round output to 2 decimals in IF(AND(ISERROR

    How can I modify the below to round the output to 2 decimals? =IF(AND(ISERROR(AOT_PricePerShare),AOT_Shares>0),-AOT_BasePrincipal,AOT_PricePerShare*AOT_Shares)
  19. N

    Modify macro

    Hi, I have the macro below so that it saves a copy of an excel sheet to pdf in folder named "chits". I need that the file name will be as cell J8. What I have to change in the macro? Thanks in advance Sub Macro1()' ' Macro1 Macro ' ' ChDir "C:\Users\littl\Desktop\chits"...
  20. T

    AutoFilter Unknown Data in Loop with VBA code

    Hi, I've found a thread in below and I would like someone help me to modify autofilter at cell CL13 https://www.mrexcel.com/forum/excel-questions/974450-autofilter-loop-vba-code.html Regards, tt3

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top