NLastCol = ('*', LookIn:=xlValues, SearchOrder:=xlB圜olumns, SearchDirection:=xlPrevious).Column 'This next variable will get the column number of the very last column that has data in it, so we can use it in a loop later You say you want to delete any column with the title 'Percent Margin of Error' so let's try to make this dynamic instead of naming columns directly.
