Ignore hidden rows?

[coffmant80]

I have a question if it's possible,

Say we don't want to delete any rows, but we hide row 3 in the image. Is it possible to have a formula or VBA to ignore the hidden row and have the calculation continue at row 4?

Thank you ahead of time for your responses.

 

[coffmant80]

I forgot to add current formulas (Duh),



Excel Formula:
M11:15 O11=IF(LEN(M11)=0,"",Q9) Q11=IF(LEN(M11)=0,"",O11+P105)

Formulas for min conversion
L105=M11 N105=L105/60/24 P105=N105

TIPS FOR FINDING EXCEL SOLUTIONS

 

[arthurbr]

As you are using lots of merged cells, which are one of XL's worst feature ( to be avoided at all costs), some complicated code might work...

 

[coffmant80]

As you are using lots of merged cells, which are one of XL's worst feature ( to be avoided at all costs), some complicated code might work...

I am sir, would it be better to use single rows & columns?