Skip Blanks

**juanp21** · 01-29-2015, 02:06 PM

Can the following formula be programed for column F

=TODAY()+(2.4/E2)

Can the program skip blank cells

Thank you

**MarvinP** · 01-29-2015, 02:21 PM

Hi Juanp,

Here is the code to do what you ask... BUT I don't think this is what you really want.

Please Login or Register  to view this content.

**juanp21** · 01-29-2015, 03:06 PM

I was using something like

For Each rcell In Range("T2:T" & ActiveSheet.UsedRange.Rows.Count)

rcell.FormulaR1C1 = "=TODAY()+(2.4*RC[-1])"

Re: Skip Blanks