Home > Forum Home > Developing and Auditing Analytical Models > Concatenate two columns? > Works Great, But... Share

Works Great, But...

Excel Help for Works Great, But... in Developing and Auditing Analytical Models


Forum TopicLogin

Works Great, But...

Rate this:
(3/5 from 1 vote)
ConfusedI use the concatenate function to help build out lengthy keyword lists, and this macro works like a charm. However, it would be great if I didn't have to edit the cell ranges in the macro each time I use it. Some times I have 3 items in column A and other times I have 30. Does anyone know of a way to make the ranges in this macro more dynamic?
 www.ProjectMatt.com
 Posted by on
 
View Full Post

Find relevant Excel templates and add-ins for Works Great, But... in the