syntax error
 

i have checked similar statements throughout the posts in this group,
and it seems that my syntax is the same...but i get a syntax error..i
dont get it

ActiveCell.Formula = "=F" & LPS "-J" & LPS "

LPS is a variable populated with a row #

syntax error
 

Maybe: ActiveCell.Formula = "=F" & LPS & "-J" & LPS "



"Nigel" wrote:

i have checked similar statements throughout the posts in this group,
and it seems that my syntax is the same...but i get a syntax error..i
dont get it

ActiveCell.Formula = "=F" & LPS "-J" & LPS "

LPS is a variable populated with a row #

syntax error
 

Your quotes and & are out of whack. Use

ActiveCell.Formula = "=F" & LPS & "-J" & LPS


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com
(email address is on the web site)

"Nigel" wrote in message
oups.com...
i have checked similar statements throughout the posts in this group,
and it seems that my syntax is the same...but i get a syntax error..i
dont get it

ActiveCell.Formula = "=F" & LPS "-J" & LPS "

LPS is a variable populated with a row #

syntax error
 

try
activecell.formula = "=f" & lps & "-j" & lps & ""

--
Don Guillett
SalesAid Software

"Nigel" wrote in message
oups.com...
i have checked similar statements throughout the posts in this group,
and it seems that my syntax is the same...but i get a syntax error..i
dont get it

ActiveCell.Formula = "=F" & LPS "-J" & LPS "

LPS is a variable populated with a row #