Skipping Blanks

  • Thread starter Thread starter Ewing25
  • Start date Start date
E

Ewing25

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
 
You could use any of these based on the direction you want to go-

Selection.End(xlToRight).Select
Selection.End(xlToLeft).Select
Selection.End(xlDown).Select
Selection.End(xlUp).Select
 
Back
Top