Results 1 to 4 of 4

Confused With modify Insert Row below base on cell value

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-11-2009
    Location
    Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    252

    Confused With modify Insert Row below base on cell value

    Hello,
    I found the code like this:
    Dim LR As Long, i As Long
    LR = Range("C" & Rows.Count).End(xlUp).Row
    
    For i = 1 To LR
        If Range("C" & i).Value > 0 Then
           Rows(i).EntireRow.Insert
            Exit For
        End If
    Next i
    with a code that will insert a row but above the target cell in column "C" when value greater than Zero, how to modify the code to insert the blank row below?
    thanks in advance
    Last edited by herukuncahyono; 07-05-2013 at 09:29 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