+ Reply to Thread
Results 1 to 4 of 4

Combine Two vba Lines(If Condition + Vlookup)

  1. #1
    Forum Contributor
    Join Date
    03-09-2004
    Posts
    140

    Combine Two vba Lines(If Condition + Vlookup)

    Hi there
    Please Login or Register  to view this content.
    how to combine these tow line to be written in one VBA line?
    Yours
    hesham Almakki
    http://www.almakki.com.ly/

  2. #2
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    1,187
    If IsEmpty(Cells(r, 14)) Then
    Cells(r, 15) = Null
    Else
    Cells(r, 15) = Application.VLookup(Cells(r, 4), AccChart2, 2, False)
    End If


    I think this is what you are trying to do

  3. #3
    Bob Phillips
    Guest

    Re: Combine Two vba Lines(If Condition + Vlookup)

    This seems too simplistic, but do you mean

    IF Not isempty(cells(r,14))
    Cells(r, 15) = Application.VLookup(Cells(r, 4), AccChart2, 2, False)
    End If


    --
    HTH

    Bob Phillips

    "helmekki" <[email protected]> wrote in
    message news:[email protected]...
    >
    > Hi there
    >
    > Code:
    > --------------------
    >
    > 'IF isempty(cells(r,14)) then leave Cells(r, 15) empty.
    > Cells(r, 15) = Application.VLookup(Cells(r, 4), AccChart2, 2, False)
    >
    > --------------------
    >
    >
    > how to combine these tow line to be written in one VBA line?
    >
    >
    > --
    > helmekki
    >
    >
    > ------------------------------------------------------------------------
    > helmekki's Profile:

    http://www.excelforum.com/member.php...fo&userid=6939
    > View this thread: http://www.excelforum.com/showthread...hreadid=392467
    >




  4. #4
    Forum Contributor
    Join Date
    03-09-2004
    Posts
    140
    Thank u very much

+ Reply to Thread

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