Hello,

This code has worked for finding the last column:
lc = ws.cells(7, columns.count).end(xltoleft).column.

However, when I used this code for a sheet that has hidden columns it would
not work.

What would be the correct code in this instance?

Please assist.

Thanks from OffDev wannabe