Results 1 to 7 of 7

Copy with offset cell containing particular character

Threaded View

Macuil0101 Copy with offset cell... 10-19-2011, 05:48 AM
p24leclerc Re: Copy with offset cell... 10-20-2011, 04:21 PM
Macuil0101 Re: Copy with offset cell... 10-21-2011, 03:21 AM
p24leclerc Re: Copy with offset cell... 10-21-2011, 07:56 AM
Macuil0101 Re: Copy with offset cell... 10-21-2011, 08:08 AM
p24leclerc Re: Copy with offset cell... 10-21-2011, 01:12 PM
Macuil0101 Re: Copy with offset cell... 10-24-2011, 05:44 AM
  1. #1
    Registered User
    Join Date
    07-01-2011
    Location
    Italy
    MS-Off Ver
    Excel 2003
    Posts
    17

    Copy with offset cell containing particular character

    Hello,
    again i need your precious help!
    I've found this code:

    Sub Search_and_Move() 
        Dim sTemp As String 
        sTemp = Range("A1").Text 
        If InStr(1, sTemp, "R", vbTextCompare) Then Range("A1").Offset(-1,11).EntireRow.Copy _ 
        Destination:=Range("A1").Offset(0,11)
    End Sub
    But I need this to run in batch for each non empty cell in range A:A. I've made several attempts but my knowledge is too low .

    If you need more details let me know!

    Thanks
    Last edited by Macuil0101; 10-24-2011 at 05:45 AM.

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