Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.37 seconds.

  1. Re: Extract and arrange the numbers small to larger values

    My pleasure & thanks for the feedback
  2. Replies
    38
    Views
    178

    Re: VBA to Make SHeet Name Equal Cell in Sheet

    My pleasure & thanks for the feedback
  3. Re: Excel stating not a valid formula when the same formula is working in another spreadsheet...

    You're welcome & thanks for the feedback
  4. Thread: workbooks.open

    by Fluff
    Replies
    1
    Views
    8

    Re: workbooks.open

    You need to put the arguments inside () when you are assigning it to a variable.
  5. Re: Extract and arrange the numbers small to larger values

    Another option
    Sub Motilulla()
    Dim Ary As Variant, Nary As Variant
    Dim r As Long, c As Long, nc As Long

    Ary = Range("E4", Range("N" & Rows.Count).End(xlUp)).Value2
    ReDim...
  6. Replies
    38
    Views
    178

    Re: VBA to Make SHeet Name Equal Cell in Sheet

    Assign this to another button
    Sub RenameSheets()
    Dim i As Long, j As Long
    j = Sheets("APPLIANCE ORDER").Index
    For i = 1 To Sheets.Count - j
    If Cells(8, i + 6) = "" Then...
  7. Replies
    3
    Views
    15

    Re: IF Formula using 'text' as a condition

    You're welcome & thanks for the feedback
  8. Replies
    38
    Views
    178

    Re: VBA to Make SHeet Name Equal Cell in Sheet

    If you delete the code you had for adding the values to G8 onwards, and then assign the new code to the button, you should be good to go.

    You can also delete all the code in the "Empty" sheets, as...
  9. Re: Excel stating not a valid formula when the same formula is working in another spreadsheet...

    You need to change the MID function to look at the 3rd character, rather than the 4th
  10. Thread: VlookUp

    by Fluff
    Replies
    12
    Views
    68

    Re: VlookUp

    Glad to help & thanks for the feedback
  11. Replies
    1
    Views
    16

    Re: Dynamic unique lists

    Something like

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col...
  12. Replies
    38
    Views
    178

    Re: VBA to Make SHeet Name Equal Cell in Sheet

    Also I forgot to change the ******* to uppercase after the board stripped it out, did you make that change?
  13. Replies
    38
    Views
    178

    Re: VBA to Make SHeet Name Equal Cell in Sheet

    In that case which line gave the error?
  14. Thread: VlookUp

    by Fluff
    Replies
    12
    Views
    68

    Re: VlookUp

    Firstly I would strongly recommend getting rid of the merged cells, they will only cause you grief & heartache.

    Try
    =IFERROR(INDEX($AM$52:$AM$164,MATCH(AA21,$I$52:$I$164,0)),"").
  15. Replies
    38
    Views
    178

    Re: VBA to Make SHeet Name Equal Cell in Sheet

    Did you change the typo I flagged in green to an i from a 1?
  16. Replies
    3
    Views
    15

    Re: IF Formula using 'text' as a condition

    How about
    =IF(ISTEXT(A1),A1,"")
  17. Re: Excel stating not a valid formula when the same formula is working in another spreadsheet...

    That file is an xls workbook which only has 65,536 rows, but you are trying to look at 1,000,000 rows, hence the error.
    With array formulae it's best to keep the number of rows to a minimum for the...
  18. Thread: VlookUp

    by Fluff
    Replies
    12
    Views
    68

    Re: VlookUp

    What cell did you put it in?
  19. Re: Excel stating not a valid formula when the same formula is working in another spreadsheet...

    If you have no space in the values in col A, then you need to change this
    (LEFT(A3:A1000000,2)
    Otherwise you will get #NUM!, but not sure why you are getting a Name error.

    Did you copy/paste the...
  20. Replies
    38
    Views
    178

    Re: VBA to Make SHeet Name Equal Cell in Sheet

    It does yes, try this mod to your existing macro
    Sub Transposing_Column_To_Row()
    Dim arrList As Object, a As Variant, i As Long, j As Long
    Set arrList =...
  21. Thread: VlookUp

    by Fluff
    Replies
    12
    Views
    68

    Re: VlookUp

    In that case where did you put the first formula, that I had in A2?
  22. Re: Excel stating not a valid formula when the same formula is working in another spreadsheet...

    You're missing a closing bracket after "CC"

    too slow
  23. Replies
    38
    Views
    178

    Re: VBA to Make SHeet Name Equal Cell in Sheet

    Yup, I understand that, but the next time you click the Button, will you still have sheets labeled KT01,KT02 etc, or will they be back to Empty1, Empty2 etc?

    Or is it safe to simply rename the...
  24. Replies
    38
    Views
    178

    Re: VBA to Make SHeet Name Equal Cell in Sheet

    That is because the description you gave & therefore what I suggested, bear absolutely no resemblance to your workbook.
    It is always better to give accurate details, rather than generalities.
    ...
  25. Replies
    1
    Views
    17

    Re: copy a sheet to a close workbook - vba

    Nope, IMO it's always safer to create & use a variable to refer to other workbooks.

    I've no idea, maybe you'd ask him, rather than us.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4