1. Jyggalag

    Neutralize/reset "info", "properties", "related dates & people" in Excel/PowerPoint

    Hello everybody, I am currently looking at excel/PowerPoint, where you have the following when you open a document: In the cases above, I have simply opened a blank document. However, what annoys me is that if I use a template from any prior documents, it will say the names of the authors...
  2. J

    Compiling and accessing nested collection within a nested dictionary

    Hi, First time posting a thread, long time user/reader of threads. I need help solving a problem that I can't find the answer (or close to the answer) to. What I want to do: Given a table of data which includes Part number, quote date, quantity, price and supplier, I want iterate through the...
  3. 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...
  4. 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()...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. J

    Question About Posting Questions Posted on Other Forums

    Hi everyone, can i post a thread present in another forum? jc
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. muhammad susanto

    Change And With Or in Complicated Function Maybe

    hi all.. i have following problem to modify this formula...
  19. 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
  20. 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)

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back