| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 # |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 # |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 # |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 # |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| runtime error: syntax error or access violation | Excel Programming | |||
| runtime error: syntax error or access violation | Excel Programming | |||
| Syntax error | Excel Programming | |||
| variable not declared error & syntax error | Excel Programming | |||
| Syntax Error Runtime Error '424' Object Required | Excel Programming | |||
![Nigel[_27_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
