IF statement macro to use end down for empty cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I construct an if statement to put the results of a calculation in the next empty cell down from any given cell? Doe example, if cell A10 is >+ 1, then put the results in the next empty cell down from cell g23, else null.
 
Functions can't do that, they can only return values where they are. You
would need VBA for that

--

Regards,

Peo Sjoblom

R. Craig said:
How can I construct an if statement to put the results of a calculation in
Click to expand...
the next empty cell down from any given cell? Doe example, if cell A10 is
+ 1, then put the results in the next empty cell down from cell g23, else
Click to expand...
null.
 

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

VBA set thick borders around non empty cells in range 0
Excel formula, sum the value cell and if empty cell left blank 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel Macro to hyperlink an archived worksheet to an index page 0
Excel Need Countifs Formula Help 0
Auto Fill Down Macro 5
Trying to run excel vba code when cell value changes from empty to entered value. 1
IF function results not displayed in cell 1

Back
Top