| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Formula help
Hi,
Thanks in advance, Can you please help me. Is says sub not found. Please help me to put following statement right Worksheets("Sheet3").Cells(4, 1).FormulaR1C1 = "=" & Address(2, 3, 1, False, "Sheet1") Thanks Trev |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Formula help
Worksheets("Sheet3").Cells(4, 1).FormulaR1C1 = "=R2C3"
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Trever B" wrote in message ... Hi, Thanks in advance, Can you please help me. Is says sub not found. Please help me to put following statement right Worksheets("Sheet3").Cells(4, 1).FormulaR1C1 = "=" & Address(2, 3, 1, False, "Sheet1") Thanks Trev |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Formula help
Thanks bob but you missed that it refers to sheet1 and not current sheet
"Bob Phillips" wrote: Worksheets("Sheet3").Cells(4, 1).FormulaR1C1 = "=R2C3" -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Trever B" wrote in message ... Hi, Thanks in advance, Can you please help me. Is says sub not found. Please help me to put following statement right Worksheets("Sheet3").Cells(4, 1).FormulaR1C1 = "=" & Address(2, 3, 1, False, "Sheet1") Thanks Trev |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Formula help
Worksheets("Sheet3").Cells(4, 1).FormulaR1C1 = "=Sheet1!R2C3"
Trever B wrote: Thanks bob but you missed that it refers to sheet1 and not current sheet "Bob Phillips" wrote: Worksheets("Sheet3").Cells(4, 1).FormulaR1C1 = "=R2C3" -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Trever B" wrote in message ... Hi, Thanks in advance, Can you please help me. Is says sub not found. Please help me to put following statement right Worksheets("Sheet3").Cells(4, 1).FormulaR1C1 = "=" & Address(2, 3, 1, False, "Sheet1") Thanks Trev -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| use vlook to show the value of a cell using a formula | Excel Discussion (Misc queries) | |||
| assign formula to another cell | Excel Worksheet Functions | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
Linear Mode
