Hello,

I have this formula which allows me to go in and highlight the cells I want it to apply to. Is there a way to run the program so I do not have to highlight. I would like it to apply to cells starting at W2 and going down til the data stops and then over to column AF. Is this possible? And for it to do it over multiple sheets?

Function GetCells(MyRange As Range)
Dim Cell As Range
For Each Cell In MyRange
If Cell <> "" Then
GetCells = GetCells & Cell.Value & " "
End If
Next Cell
If GetCells <> "" Then GetCells = Left(GetCells, Len(GetCells) - 1)
End Function
Sub Concatenate()

End Sub