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,...
Type: Posts; User: jomili
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,...
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...
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...
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...
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...
Rajan,
The example file doesn't appear to be on OneDrive any longer. Can you repost?
Now we're cooking! That works great!
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...
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...
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...
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...
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...
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...
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 =...
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,...
Glad I could help. Pointing out problems is the easy part. Thank you for doing the hard part.
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...
Thanks, I didn't know any better, so I'll try to remember that in the future.
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...