Reset Command

[RickyGregory]

I have the follow code to set cell AF8 to a blank cell

Sheets("Main Sheet").Range("AF8").Value = ""

Is it possible to have the following code write to cell AF8

"=LOOKUP(2,1/(DATA!L1:L20212<>""),DATA!L1:L20212)"

so the full code will read

Sheets("Main Sheet").Range("AF8").Value = "=LOOKUP(2,1/(DATA!L1:L20212<>""),DATA!L1:L20212)"

Many thanks

[Special-K]

Shouldn't that be

Sheets("Main Sheet").Range("AF8").Formula = "=LOOKUP(2,1/(DATA!L1:L20212<>""),DATA!L1:L20212)"

[Special-K]

Shouldn't that be

Sheets("Main Sheet").Range("AF8").Formula = "=LOOKUP(2,1/(DATA!L1:L20212<>""),DATA!L1:L20212)"

[RickyGregory]

Hi Special K

I should have said ealier the above code came back with an error, ive entered your code and it still shows an error