Search:

Type: Posts; User: DanteAmor; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.06 seconds.

  1. Replies
    7
    Views
    98

    Re: Conditional - multiple conditions

    Do you have an empty cell or a blank space?

    Try this

    =SUM(IF((TRIM(B1:H1)<>"")*(B1:H1<>0),1,0))+SUM(IF((TRIM(J1:W1)<>"")*(J1:W1<>0),1,0))=21
  2. Replies
    9
    Views
    146

    Re: 1004 on assignment statement

    Good luck
  3. Replies
    2
    Views
    108

    Re: Count if formula required

    I changed the dates from 25jun to 26jun to perform the tests and my results do not match your example.
    You could comment.

    <table style="font-family:Arial; font-size:12pt; border-style: groove...
  4. Re: How can I find the range in which is cell falls when the ranges are not continuous?

    You could explain with real data what you have on each sheet and the expected result.
  5. Re: Macro to create a new row and copy data

    Try this



    Sub Create_New_Record()
    Dim u As Long
    Application.ScreenUpdating = False
    For i = Range("A" & Rows.Count).End(xlUp).Row To 1 Step -1
    If LCase(Cells(i,...
  6. Re: Moved PDFs from one location to another

    Try this.
    Change data in red by your information



    Sub SaveasPDF()
    Dim wsA As Worksheet, strName As String, strPath As String, strPathFile As String
    Dim wUser As String, wDesk As...
  7. Replies
    19
    Views
    255

    Re: Missing End If error

    Okay, let's wait for the tempest to subside.

    Also, you have a great day.
  8. Re: Moved PDFs from one location to another

    delete
  9. Re: Return Cells in a Sequence that's Greater then Zero

    I'm glad to help you. Thanks for the feedback.
  10. Replies
    3
    Views
    87

    Re: Easier way to write this?

    I did not understand what the pattern is.
    But try the following.




    Sub testerdelete()
    Application.ScreenUpdating = False
    Application.EnableEvents = False
    ActiveSheet.Unprotect
  11. Re: vba code doesn't work; same code works as a macro

    So it works already?
  12. Re: Return Cells in a Sequence that's Greater then Zero

    Try this array formula


    <table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; "...
  13. Re: Index and Match values in a cell seperated by commas

    Hello, it is not clear if you have the data on a sheet or in several sheets.
    I also do not understand if the result is on the same sheet or on another sheet.


    I understand that in cell A1 you...
  14. Replies
    4
    Views
    70

    Re: Look-up from 2 excel files.

    I'm glad to help you. Thanks for the feedback.
  15. Re: vba code doesn't work; same code works as a macro

    You can put your complete code here.
    What do you have in the variable naamSp?


    Do you want to copy the formula or take the value?
  16. Replies
    7
    Views
    98

    Re: Conditional - multiple conditions

    Select cell A1 and in conditional format, in formula put the following:

    =SUM(IF((B1:H1<>"")*(B1:H1<>0),1,0))+SUM(IF((J1:W1<>"")*(J1:W1<>0),1,0))=21

    It works for any value in the cells...
  17. Replies
    2
    Views
    72

    Re: VBA Coding - Excel keeps crashing

    I made some adjustments to your code, and I have no problems.
    Try and tell me.



    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Not Intersect(Target, Range("B:B")) Is...
  18. Re: Excel2016. Return several criteria for an article as text

    Try the following UDF.
    Put the code in a module and use the function as shown in the following example:

    <table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt;...
  19. Re: VBA to Copy Specific Cells into all Worksheets

    Try this



    Sub NewSheets()
    Dim sT As Worksheet, sD As Worksheet, i As Integer, sN As Worksheet

    Application.ScreenUpdating = 0
    Set sT = Sheets("Template")
    Set sD =...
  20. Replies
    4
    Views
    70

    Re: Look-up from 2 excel files.

    Try this

    =IFERROR(INDEX('[Product Masterfile.xlsx]Sheet1'!$C$8:$C$65536,MATCH(L1202,'[Product Masterfile.xlsx]Sheet1'!$E$8:$E$65536,0)),IFERROR(INDEX('[Archive Product...
  21. Re: Find cell value using multiple criteria and a header row that does not always have a value

    That's right, the Z10 is the final cell.


    In my example, row 2 contains the codes, and row 3 is empty, so add 2 to start with the prices.
  22. Re: Moved PDFs from one location to another

    Your macro only saves the active sheet in PDF:



    Set wsA = ActiveSheet
    wsA.ExportAsFixedFormat _


    I do not know why you select the sheets in this part:
  23. Replies
    6
    Views
    170

    Re: Insert New Row From Drop Down

    Sorry, but I still do not understand.
    This has to do with the original requirement or is it a new request?
  24. Replies
    19
    Views
    255

    Re: Missing End If error

    I'm sorry, but I do not understand what you want me to help you with.
    You can explain how it works, which sheet I go to, which form, which macro.


    Explain in detail and with examples, especially...
  25. Replies
    13
    Views
    185

    Re: 3x Checkboxes - Hide/Unhide sheet

    Sorry, but I do not understand.
    You can tell step-by-step what to do in your file and what you expect in each step.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4