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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

skip blank rows 2
Skip condition if cell is blank 2
Combine 2 columns in a dynamic range into one 7
Issue with blanks and spaces 56
Help needed 0
Help repeating formulas with skips 1
Create if partial match then copy and paste data from one cell to another 1
Excel formula, sum the value cell and if empty cell left blank 0

Back
Top