Results 1 to 4 of 4

Cleanup (addendum) - looking to clean this up

Threaded View

  1. #1
    Registered User
    Join Date
    04-24-2012
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2007
    Posts
    16

    Cleanup (addendum) - looking to clean this up

    Similar to an earlier post, other priorities came up, now looking to resolve this issue again.
    Thanks for the assistance
    Sub Get_Data_For_Copy()
           
        Cells.Find(What:="#Last_Row", After:=ActiveCell, LookIn:=xlComments, _
            LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
            MatchCase:=False, SearchFormat:=False).Activate (Result is A36061 need to subtract 1 row - (value should be A36060))
        
    Cells.Find(What:="#Last_Col", After:=ActiveCell, LookIn:=xlComments, _
            LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
            MatchCase:=False, SearchFormat:=False).Activate (Result is CQ1 need to subtract 1 column - (value should be CP1))
    )
    
        Range("A5:CP36060").Select    (Always will start from A5(Value here should be from above finds -1 (CP36060))
        Range("A36060").Activate
        Selection.Copy
    End Sub
    Last edited by arlu1201; 06-05-2012 at 02:23 PM. Reason: Code tags needed here.

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