Something like this i assume?

If ActiveSheet.Name = "Sheet1" Then
Columns("B").Select
End If

"Bugaboo" wrote:

I have a macro that will copy and add a sheet, and name it for each name in
the first row.

I now need to select the column in each sheet where the sheet name and
header name are the same and set the background to gray. The number of
columns and rows will vary.

Is this possible to do?

Thanks for all your help. I use this site a lot.