+ Reply to Thread
Results 1 to 5 of 5

Copy or Move rows starting with a particular cell value until next blank row

Hybrid View

sborda Copy or Move rows starting... 11-27-2012, 04:58 PM
arlu1201 Re: Copy or Move rows... 12-04-2012, 08:23 AM
sborda Re: Copy or Move rows... 12-04-2012, 12:57 PM
sborda Re: Copy or Move rows... 12-04-2012, 05:36 PM
arlu1201 Re: Copy or Move rows... 12-05-2012, 07:53 AM
  1. #1
    Registered User
    Join Date
    10-24-2012
    Location
    California
    MS-Off Ver
    Excel 2011
    Posts
    2

    Re: Copy or Move rows starting with a particular cell value until next blank row

    Hi this was solved in StackOverflow:

    Sub CopyDepth()
        Dim ws As Worksheet
        Dim rng As Range
        Set ws = Worksheets("Profile")
        Set rng = ws.UsedRange.Find(What:="Depth (m)")
        Range(rng, rng.End(xlToRight).End(xlDown)).Copy
        Worksheets("data").Range("A1").PasteSpecial
    End Sub
    Last edited by arlu1201; 12-05-2012 at 07:52 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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