ubounda

Hey guys I am trying to convert the code below to a function, I am trying to sort the data below the code by the first set of numbers it comes to. I think this would be the formula I would want to enter, or close to it "=vsortm(a1, a:a)" This code works fine the way it is, but I need to use it...

I'm wondering if someone can please help me out in creating a template VBA I can use to "expand" a list I create for doors on different new designs we do. I tried doing a pivot table but it doesn't go as in-depth so I believe creating VBA that I can use to create the new list is best. I have...

This code do exactly what I need but I can't figure it out how to adapt it to my needs... Please can you tell me how can I change this to work instead searching from A1:C and coping missing data to D1:F to work only comparing two columns J1:J and K1:K Attach...

Hi, How can I delete only empty columns within a selected range This is the code I am using, It merges columns together based on string delimited input but I want to delete only the empty columns from the column selection, Can someone help with this please Sub MergeColumns() Dim i As...

Hello Excel Masters, I am trying to compare records in column A and B and mark in column C the found entries (1 for found, 0 for not found). My basic task is the following: In column A I have e-mails of people who were invited to a meeting, in column B I have e-mails of all the people who...

I have a macro splitting multiplte sheet depending on coloumn (A) in all the sheets and freezing top 2 rows while runnig the macro error reflecting Runtime Error 1004 Cannot rename a sheet to the same name as another and the macro not executing can it be done to flexible with freezing the...

Hi I need to get the elements of 2D array Sub ttt() Dim a(2, 6) As Integer a(1, 1) = 10 a(1, 2) = 20 a(1, 3) = 30 a(1, 4) = 40 a(1, 5) = 50 a(1, 6) = 60 a(2, 1) = 10 a(2, 2) = 20 a(2, 3) = 30 a(2, 4) = 40 x = UBound(a, 1) - LBound(a, 1) y = UBound(a, 2) - LBound(a, 2) MsgBox y & " : "...

Hello Sir, The macro will work upto 1.25 lak rows with 110 column, but throws error if it exceeds 1.25 lakh rows with following message Run time error 7 over flow error. How could it be fixed Special thanks to Jindon Sir for providing short code to perform lookup function. However when I...