Auto Cell Detect

Hi Guys,

I'm working on a little project and I've come to another brick wall in terms of programming the Macro. I'm trying to simply multiply any cell that is in a set range by 1.8515. I say "In Range" because there are empty cells between the cells with values and if I apply to an entire column the empty cells result in having 1.8515 in them which I do not want.

Layout:The Values to be converted are in Column N

Now the final product (multiplying column N value by 1.8515) must be located in column C.

I was simply going to use a "Product=NCell, 1.8515" then a Auto fill but when i auto fill it selects all the cells with no values in them also which results in having 1.8515 in them which is not a option. Is there a way so that the only cells modified in column C are the ones that only have values in column N.

If i have not explained this well i have uploaded a sheet showing how it is layed out.

This is part of a Macro which automattically sets up the sheet and performs the equations and this is another step being implemented into it. And thankyou what you provided i can implement in, i didn't know you could have if statements in the actual equations.

Thankyou