Thread: Combine Two vba Lines(If Condition + Vlookup)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
helmekki[_86_] helmekki[_86_] is offline
external usenet poster
  
Posts: 1
Default Combine Two vba Lines(If Condition + Vlookup)

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

Reply With QuoteReply With Quote