+ Reply to Thread
Results 1 to 3 of 3

Range Selection up to last visible adjacent cell,filter,copy paste to next sheet

  1. #1
    Registered User
    Join Date
    01-04-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    8

    Range Selection up to last visible adjacent cell,filter,copy paste to next sheet

    Hi
    this is in continuation to

    http://www.excelforum.com/excel-prog...-is-blank.html

    My data will be having Columns a,b,c,d and so on. I want to copy paste macro from d which I got from above thread. now further to that I want to filter the data in d, copy upto last visible adjacent cell and paste in other sheet.

    Sub CITY()
    '
    ' CITY Macro
    '

    '
    Selection.AutoFilter
    ActiveSheet.Range("$A$1:$D$37").AutoFilter Field:=4, Criteria1:="AP"
    Range("A2:D33").Select
    Selection.Copy
    Sheets("STATE").Select
    Range("A2").Select
    ActiveSheet.Paste
    Application.CutCopyMode = False
    End Sub


    in range how to make selection upto last adjacent cell.MASTER2.xlsm

  2. #2
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,517

    Re: Range Selection up to last visible adjacent cell,filter,copy paste to next sheet

    See if this will help
    Attached Files Attached Files
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.

  3. #3
    Registered User
    Join Date
    01-04-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Range Selection up to last visible adjacent cell,filter,copy paste to next sheet

    thank a lot

+ Reply to Thread

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