This will not consistantly work for some reason- Sometimes it goes all the way back to column A and sometimes it comes up short and stops at Column B which causes it to crash. Can Offset be told to go back to the beginning of the columns (column A)? or is there another line of code for VB that will do that?Sheets("Pending Approvals").Select ActiveWorkbook.Save Sheets("Blank Form").Select Application.CutCopyMode = False ActiveWorkbook.Save Rows("1:65").Select Selection.COPY Sheets("Pending Approvals").Select Range("A1").Select ActiveCell.SpecialCells(xlLastCell).Select ActiveCell.Offset(rowoffset:=1, columnoffset:=-92).Activate ActiveSheet.Paste ActiveWindow.SmallScroll Down:=33
Thanks!
Bookmarks