Hi All,
I'm new in VBA and learning a lot (reading VBA excel 2007 for dummies lol) but for work I need a very simple routine to create so please help on this.
So I have a calculation to do (see cell Q4 on image attached) where the variables to enter are s1,g1, s2,g2 etc.... In some cases I will only have s1 and g1 and the rest (s2,g2 etc...) will be zeros. As you can guess I cannot put 0's because I will get errors, however I can not either put a empty cell.
So this is why I want to create my first subroutine, where the variables will be from F5 to P5 and be able to drag down the formula to compute the same calculation for the lower rows.
Could someone give a hand on how to start this? As I said, I'm reading a book but the examples they give are so basic and takes a lot of time.
Thank you,
Bookmarks