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
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?
Thanks!
Bookmarks