Apply formula to a certain column ( attempt made )

**Tmc2159** · 06-17-2013, 04:43 PM

Hi ALL

So i am slowly learning to write macros.

I want column AJ to be automatically filled using the formula that appears in my code

Unfortunately, my code does not run

Please Login or Register  to view this content.

Anyone know what the issue is.

The formula works when i just put it in myself into the first cell.

**Tmc2159** · 06-17-2013, 04:45 PM

DELETED this particular post myself because it s against rules

**Mordred** · 06-17-2013, 04:46 PM

You haven't put a value to LR. As it is, the default value for LR is 0 so therefore the Range("AJ2:AJ" & Lr) will be equivalent to AJ2:AJ0 which cannot be done.

**Mordred** · 06-17-2013, 04:47 PM

Originally Posted by Tmc2159

If possible i would like this formula to be applied to the first empty column too but not sure how to do that

First empty column at which row? Or, do you mean the first empty cell at an unknown row?

**Tmc2159** · 06-17-2013, 05:07 PM

I have a bunch of columns with data.

I want this formuila to be applied when I no longer have data ( the first blank column ).

The formula:

=I2*10000*(((((0.074*((S2+T2)/S2)^3)-(0.6406*((S2+T2)/S2)^2)+(2.6145*((S2+T2)/S2))-1.8879)*3600*2)*SQRT(298.15/(R2+273.15))*1.2943)+(((-87.297*(((C2*1.0593)-14.434)/3800)^3)+(309.6*(((C2*1.0593)-14.434)/3800)^2)-(311.63*(((C2*1.0593)-14.434)/3800))+303.7)*((C2*1.0593)-14.434)/1000000))*0.001517/((C2*1.0593)-14.434)

would of course evolve so that I2 changes into I3 and so on for the other cells called

I don't want it to put anything in the first row, that will be my header row.