Use the SMALL Function in VBA

**maacmaac** · 12-27-2011, 04:22 PM

In spreadsheet, I have invoice numbers in columns A-F, I need to combine(concat) the cells and enter result in column G. I have macro that will do this however, I want to list the invoices numbers from lowest to highest in column G. I was trying to use the SMALL function within the VBA but can't seem to figure out a solution. Thanks. (small sample attached w/ expected results if needed).

Please Login or Register  to view this content.

**tom1977** · 12-27-2011, 04:36 PM

try this

Please Login or Register  to view this content.

**maacmaac** · 12-27-2011, 05:02 PM

Tom,

I was looking again at my data and some of the rows contain less that 6 invoice numbers. I should have mentioned in my first post...sorry. For example, row number 5 may have an invoice number for columns 1,2,3 but columns 4,5,6 are blank. With this occurs, it is creating a run time error. Thanks