Should bestrNum = .Cells(LastRow, 1)strNum = .Cells(lngRow, 1)
Should bestrNum = .Cells(LastRow, 1)strNum = .Cells(lngRow, 1)
Graham Mayor - MS MVP (Word) 2002-2019
Visit my web site for more programming tips and ready made processes
http://www.gmayor.com