ActiveCell.Formula

Giganews Newsgroups
Subject: ActiveCell.Formula
Posted by:  Leif Ramussen (anonymo…@discussions.microsoft.com)
Date: Fri, 17 Oct 2003

Hi
How on earth do I make the following formula to function ?

TempNumber=15
ActiveCell.FormulaR1C1 = "= TempNumber*R[-2]C"

I have tried val() and different combinations of & and "

Hobe somebody will reply.

Kind regards
Leif Rasmussen

Replies