Results 1 to 3 of 3

Copy For Cell Values Present and not Formulas Present

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-10-2008
    Location
    Austin
    Posts
    660

    Copy For Cell Values Present and not Formulas Present

    The following code fills down column B for rows 3 to 110, regardless
    of the inserted "If Not IsEmply' statement.
    I've got formulas in Column A from row 3 to 110, but visible values in
    rows 3-5. I want it to fill the for the visible values only.

    Sub CopyTest()
    Dim OutPL As Worksheet
    
    Sheets("Pull").Activate
    lastrow = Cells(Rows.Count, 1).End(xlUp).Row
     For i = lastrow To 3 Step -1
       If Not IsEmpty(Cells(i, "A")) Then
          lastrow = Cells(Rows.Count, 1).End(xlUp).Row
       Set OutPL = Sheets("PULL")
    OutPL.Cells(i, "B").Value = Sheets("Bill OF MATERIAL").Cells (4, "D").Value
         End If
              Next i
                        End Sub
    Any help is appreciated.

    Thanks,

    BDB
    Last edited by bdb1974; 09-11-2009 at 12:11 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