Hi there
how to combine these tow line to be written in one VBA line?Please Login or Register to view this content.
Hi there
how to combine these tow line to be written in one VBA line?Please Login or Register to view this content.
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
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
>
Thank u very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks