Type: Posts; User: steve the fish; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.22 seconds.

  1. Re: VBA Code - Closing Statement Wrong Perhaps

    You are missing two End With statements i can see which is a surprise as this is a recorded macro.

    Replace this section:

    Selection.NumberFormat = "m/d/yyyy"
  2. Re: if date falls on weekend, roll to Monday

    Try this:

  3. Re: Place sub category's letters in all items

    First check this formula does what you expect in all of your data. I need to understand your rule.

  4. Re: Place sub category's letters in all items

    Where does FRUI and BAKE come from??
  5. Re: How to get 1 vba code to run on all sheets in my workbook when active?

    Right click on ThisWorkbook, view code and use Workbook_SheetBeforeDoubleClick
  6. Re: Help with conditional SUMPRODUCT to also ignore blanks

    The double negative in front of this bit:


    is there to convert a TRUE/FALSE result into a 1 or 0 result. You need the double negative in front of your new TRUE/FALSE test.
  7. Replies

    Re: Help with Select Case

    No it's an integer. Match will produce the position in the array. 1 for monday 2 for tuesday etc.
  8. Re: If blank cel then dont calc Networdays - Formula Not working

    Because that isnt the syntax for networkdays. It requires at least a start date and an end date.
  9. Re: formula to get the value of the same cell but in different sheets

    You will need to put the sheet name in a cell then do something like:


    where A1 holds the name of the sheet you are interested in.
  10. Re: Error in index+match multiple criteria


    =INDEX('VICEPROCESS NE DN'!$D$2:$S$4236;MATCH(1,(D2='VICEPROCESS NE DN'!$D$2:$D$4236)*(E2='VICEPROCESS NE DN'!$E$2:$E$4236)*(F2='VICEPROCESS NE DN'!$F$2:$F$4236);0);16)
  11. Replies

    Re: Help with Select Case

    You could also see if this does the same thing:

    dayInt = Application.Match(Me.lDay, Array("monday", "tuesday", "wednesday", "thursday", "friday", "saturday", "sunday"), 0)
    shSum.Range("B" & 2 *...
  12. Replies

    Re: Help with Select Case

    Do you mean something like this instead? Notice the use of LCase so make all your days lower case.

    Select Case LCase(Me.lDay)
    Case "monday"
    'Do this
    Case "tuesday"
  13. Re: VBA - Change inputBox date from US to UK standard (mm-dd-yyyy -> dd-mm-yyyy)

    Presuming your local date setting is dd/mm/yyyy then try somthing like this:

    x = InputBox("Enter Date in format DD-MM-YYYY")
    Range("A1") = CDate(x)
  14. Re: How to Re-Write a Very Long Formula

    See if this always produces the same results:

  15. Replies

    Re: Index and Match formula

    Hi. Number 1 would require more info. If a match doesnt find a match then the result is #N/A. You havent given much away in terms of why that may be. Number 2 probablt means the index match match...
  16. Re: VLOOKUP MATCH Not returning all results

    From what you describe i cant see any problem that immediately comes to mind. Certainly cant explain randomness as i cant see that thats possible. In the first row that produces an erroneous result...
  17. Re: runtime error '380 Could not set the rowsource property. Invalid property value

    Do you have a sheet called 'Sheet1'
  18. Re: Excel Date Formula - Production Log

    Yes the way ive written it here 'holidays' is a named range but you could just replace it with cell references. Once we reach november the formula will adjust to look for november dates. This...
  19. Re: Excel Date Formula - Production Log

    Always good to give an example. Worth many words. Try this:

  20. Re: Excel Date Formula - Production Log

    Hi. If im understanding you want the number of days that appear between those two dates that are in the current month but starting from today? If so try:
  21. Re: how to use a cell to reference a file?

    As i was trying to say in post number 12 if you type anything into a cell with a leading ' excel will use that ' to think you mean this is text and ignore it. Therefore your indirect will fail as it...
  22. Re: how to use a cell to reference a file?

    You will be losing the initial ' if you type that as the first character in a cell.
  23. Replies

    Re: VBA Code Error

    The macro recorder up until recent versions of excel just didnt work with long formulas. It cuts off 8 digits at each line feed from memory. See if this is better:

  24. Re: VBA code to lookup value in column

    Ok so check this formula works as intended.

    =VLOOKUP(D8,'Pallet and Truss Data'!$A$9:$Z$250,D8*4+1,FALSE)
  25. Re: VBA code to lookup value in column

    The lookup formula can be just this:

    =VLOOKUP(D2,'Pallet and Truss Data'!A9:Z250,$D$8*4+1,FALSE)

    Im not sure what the line that begins with 'The Value' means.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4