Continue formulas in next rows VBA

Hi All,

I have a spreadsheet which contains some formulas in some cells (see attached for better understanding). There is a table in the spreadsheet which starts from column B to clumn J. By inputting values to cells in Column C and D the rest of the cells in that row will do some calculations as it is clear in the spreadsheet. instead of dragging down the formulas is there any way in VBA to define if the cells in column B (or C or D) not empty then do the calculations in that row. i.e if "B12" is not empty do the calculations (E12 to J12) and then move on to the next row and so on..... I hope it is clear!

Thanks,

Thanks for your reply Kevin but the problem in this case is data in column B, C and D will be inserted by a piece of code which search for the last row and insert data. when I delete data for new entries the last row will be the last row that table created i.e if I insert data in row 12 to 15 and delete the data and insert new set of data it will start from row 16.

the alternative solution to this is, if possible, clear the table as well as data which I don't know any VBA code for it.

Thank you both. All 3 options work perfectly.

It works perfectly but I have one concern here. I need to add a push button and assign the macro to run the code and the calculations and calculations won't be shown until i click the button. What should I do the calculations will be shown automatically when column B,C and D (or either of them) has value?

Cheers

Originally Posted by Kevin#

I have assumed there will always be values in Column B
- if you want formulas in the cells use Option1
- for values only use Option2

The attached workbook includes 2 sheets to illustrate both (formulas in sheet1, and values in sheet2)

Option1

Please Login or Register  to view this content.

Option2

Please Login or Register  to view this content.

You're a star!

Originally Posted by Kevin#

If you want the macro to run automatically then insert this line (in the code that updates columns B:D) after that code has updated the values in columns B:D

Please Login or Register  to view this content.

(or Call AddValues)