Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Skipping Blanks
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 "Ewing25" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Skipping Blanks (Again) | Excel Discussion (Misc queries) | |||
Skipping Blanks | Excel Discussion (Misc queries) | |||
Loop while skipping blanks | Excel Programming | |||
Skipping blanks | Excel Discussion (Misc queries) | |||
Paste Special Skip Blanks not skipping blanks, but overwriting... | Excel Discussion (Misc queries) |