Search:

Type: Posts; User: jomili

Search: Search took 0.00 seconds.

  1. Replies
    4
    Views
    6,417

    issue: I put it into my PERSONAL, but in running...

    issue: I put it into my PERSONAL, but in running it I got a "Subscript out of Range" at this line:
    .Range("a1").Resize(, UB2).Value = ThisWorkbook.Worksheets(Replace(ShtName, i - 2,...
  2. Replies
    4
    Views
    6,417

    Thanks. Now I've got it straight. For "Select...

    Thanks. Now I've got it straight. For "Select the data range(including column header)" that means A1:I64, IE the whole table, and for "Select the unpivot data range(only column header)" I'd select...
  3. Replies
    4
    Views
    6,417

    Tried to give it a whirl but no go. I've...

    Tried to give it a whirl but no go. I've attached my pivot so we can understand each other. For "Select the data range(including column header)" I take that to mean D1:I64. But when it says "Select...
  4. SNB, I know it's years later, but I just ran...

    SNB,
    I know it's years later, but I just ran across this post. Testing your function, if I input "451" I get a proper response of "Four Hundred Fifty One". However, if I input "451.27", I get...
  5. When I do this column comparison I want a...

    When I do this column comparison I want a permanent record without interfering with my source data, so put it on another sheet. Also, I don't always want to compare A and B, sometimes it's J and Q or...
  6. Replies
    1
    Views
    6,329

    Rajan, The example file doesn't appear to be on...

    Rajan,
    The example file doesn't appear to be on OneDrive any longer. Can you repost?
  7. Replies
    12
    Views
    34,308

    Now we're cooking! That works great!

    Now we're cooking! That works great!
  8. Replies
    12
    Views
    34,308

    SNB, I always like your code, but this current...

    SNB,
    I always like your code, but this current version has a hiccup, and I don't easily see how to fix it. Going with your sample, if instead of Selecting "Teak Color" I key it in in the search...
  9. Replies
    5
    Views
    3,156

    Thanks Admin, that did the trick! Just a...

    Thanks Admin, that did the trick! Just a suggestion, but this is my second question on MLookup (I posted earlier about how to use it). Do you think both the direction on how to use, and the updated...
  10. Replies
    5
    Views
    3,156

    Okay, I found the differences in the code, but...

    Okay, I found the differences in the code, but can't see where the Nth Match is impacted by the changes. However, that seems to be the case. As it was originally posted, at...
  11. Replies
    5
    Views
    3,156

    I've examined the code and can't discover where...

    I've examined the code and can't discover where it differs from the code in the workbook. Can you pinpoint the difference for me?

    Putting "True" at the end, using the new code, works to fill the...
  12. Replies
    5
    Views
    3,156

    MLookup not returning results

    I'm wanting to include the MLookup function in my addin, so I can let others use it, but I'm having trouble with the usability of the function itself. I have one workbook example where I use...
  13. Replies
    5
    Views
    4,255

    MLookup:How to use

    I've copied the code from http://www.excelfox.com/forum/f12/vlookup-return-multiple-values-4/, but I'm restricted from downloading the example. I can't figure out how to use the function as a...
  14. Replies
    1
    Views
    1,575

    Okay, I've achieved partial success by changing...

    Okay, I've achieved partial success by changing my column order to add the last column (AB, the one that disappears) twice:
    Const NewOrder As String =...
  15. Replies
    1
    Views
    1,575

    Swapping columns Error 2

    I previously posted about a problem I was having with Rick's column swap macro (http://www.excelfox.com/forum/f22/swapping-rearranging-multiple-columns-data-493/index2.html). Now I'm back again,...
  16. Replies
    5
    Views
    2,965

    Glad I could help. Pointing out problems is the...

    Glad I could help. Pointing out problems is the easy part. Thank you for doing the hard part.
  17. Replies
    5
    Views
    2,965

    Update: I've got a workaround. If create column...

    Update: I've got a workaround. If create column "AF", "Trash Column", and add AF as the last item in my string of columns (see below), it gets left as the last column, whereupon I can delete it and...
  18. Replies
    5
    Views
    2,965

    Thanks, I didn't know any better, so I'll try to...

    Thanks, I didn't know any better, so I'll try to remember that in the future.
  19. Replies
    5
    Views
    2,965

    Swapping Multiple Columns of Data

    Rick,

    I'm using your SWAP Columns macro , and am having an issue. See the attachment with before and after sheets. I've posted the macro below, configured the way I'm using it. The problem is...
Results 1 to 19 of 19