Thread: Skipping Blanks
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ewing25 Ewing25 is offline
external usenet poster
 
Posts: 62
Default Skipping Blanks

Hello Again!

So i have a simple IF formula in a cell that populates the cells based on a
number in another cell from another sheet named Received

There are a lot of spaces between the values.

Is there anyway I can make it in VBA so it skips the blanks?

This is the If statement:
=IF(Received!A2=0,Received!B2,"")

Thanks!
Alex