General not Text Format

[ParanoidAndroid]

I have a macro which puts a simple formula into a column -

"=I2" into Y2 and then clicks and drags the formula down the column/page

For some reason it keeps converting it to Text format...

I manually change it back to general format and the macro "=I2" stays general the first time i rerun the macro but the second time i run the macro it reverts back to text.

Is there a way i can lock column y so thats it always General format?

 

[AlphaFrog]

You could have your macro set the cell format to general after you set the formula in Y2.

As an example...

LastRow = Range("I" & Rows.Count).End(xlUp).Row
With Range("Y2")
    .Formula = "=I2"
    [COLOR="Red"].NumberFormat = "General"[/COLOR]
    .AutoFill Destination:=.Cells.Resize(LastRow - 1)
End With