10% Prepaid to Ozgrid
I am using a UDF to concatenate similar values based on criteria in columns in a worksheet (Review). The formula that calls the UDF is in a table on another sheet (Ratings). The table will show names in a cell based on matches in the criteria in the formula. Also, the UDF places each new value in the cell under each other similar to CHAR (10) to make it look clean. As values change based on input in columns from the Review sheet (Column Y, VCC Rating), the rows in the table do not want to expand or "Autofit" to account to more values being added or being removed from cells. Is there code that can be added to the UDF that will automatically autofit the rows of the table after values are changed in Column Y in the Review sheet. Every other column value that effects the table is static except for Column Y.