worksheetfunction.match

I have 2 VBA codes that are almost identical to each other, the only difference is that one of them has a prompt for message box with input to fill in column B. Basically code 2 is identical to code 1, but with all the columns shifted one down (B-C, C-D, etc). Below is code 1 Private Sub...

Hi all, I'm having an issue with my VBA code not "finding" the match in the correct column. When I use the formula =MATCH(MID(Sheet3!A4,13,10)*1,A1:AE1,0) it gives 2/1/2016 to match the header 2/1/2016, it gets me the value 21 which is Column V on my sheet. This is correct. I'm after the...

Oh silly Match function. How you vex me so! I am using WorksheetFunction.Match() to identify the location of values in a range. Some of the values in the range are strings. Some of the values are dates. And guess what? Match chokes on the dates. It's clearly a type mistmatch issue...

Hi Guys, I have a table that is divided in 3 blocks. Headers start from B3:BZ3 and has max of 31 rows. Problem is that the 3 block vary in horizontal dimensions daily. For example my first block would be B3:P33 on one day and B3:AE3 the other day. and same with other blocks of data. Fortunately...

All, The MAX function works fine but the MATCH does not. I am trying to obtain a column number. MATCH works with hard code but I need to use a variable. As soon as I attempt to make the range a variable, it fails Dim myRange As Range myRange = Worksheets("tbl_Allocations").Range("E6:P6")...