Results 1 to 9 of 9

Do only if Cell not empty on range

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-19-2011
    Location
    Central Europe
    MS-Off Ver
    Excel O365
    Posts
    364

    Do only if Cell not empty on range

    Hi all

    I am running this code:

    With Range("O:O")
    With Target
    If .MergeCells Then Call Notmerged Else .EntireRow.AutoFit
    If Not .MergeCells Then .RowHeight = .RowHeight + 5
    End With
    End With
    It's running fine, except I would not like it to run if the value in col. O is empty
    I should incorporate this in this line
    If Not .MergeCells Then .RowHeight = .RowHeight + 5
    Any ideas?

    Thx
    FD
    Last edited by FallingDown; 07-05-2013 at 03:18 AM. Reason: Solved

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