Results 1 to 4 of 4

Can Column Offset in VB code be told to go to column A?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-08-2009
    Location
    Missouri
    MS-Off Ver
    Excel 2003
    Posts
    183

    Can Column Offset in VB code be told to go to column A?

        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!
    Last edited by mrgillus; 08-19-2009 at 03:13 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1