You are inside a With statement, so your cells and range references need a period in front of them to tie them to the object. But maybe this would work in place of what you are trying:
although I am not sure why you are using autofit at that juncture.![]()
.Columns.AutoFit .Range("B1:B12").ClearContents
Bookmarks