Is it possible to drop a wildcard into write range to get a dynamic column?

Currently having to deal with a column name that is super long and I may need a wildcard
to find and write the range using the code below is this possible?

Is it possible to retrieve a dynamic column name using a wildcard if so how?