Hi all,

I have columns D through BD where data is pasted from another workbook, one column per week (via code).

So unused columns on the right are hidden. They are not completly unused as there are rows with formulas..

Based on row 3 I am trying to:
When the data (for this week as example) is pasted in then that coulmn will be unhidden.

I am trying to change the 'End(xlToLeft)" to work with 'Columns D through BD' only.
Cells(3, Columns.Count).End(xlToLeft).Offset(0, 1).EntireColumn.Hidden = False

I can't use that, because columns to the right, BE through BF have data and that is blocking.

Any direction is surely appreciated.