| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cells within Cells formula
Hi Guys
This is an example of one of the formulas that I am trying to use. Dim x As Long x = 2 Cells(x, "C").Formula = "=(Data!Cells(x, "P")+Data!Cells(x,"R")/24" It keeps giving me a compiled error, unexpected end of statement. It keeps pointing to the P and I can't figure out how to get around it. I've tried single quotation marks, putting them in separate brackets and what not but it doesn't work. =/ I'm stumped, guys. Help would be appreciated. -Simon the newbie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula refers to empty cells even when cells contains data | Excel Worksheet Functions | |||
| Setting of input cells as blue font and formula cells as black fon | Excel Discussion (Misc queries) | |||
| Need formula that will sum cells in a column bases on criteria in other cells. | Excel Worksheet Functions | |||
| trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
| Copy a formula to a range of cells via VB6 using .Range(Cells(row,col), Cells(row,col)).Formula= statement | Excel Programming | |||
Threaded Mode
