Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Using the following code causes an error 1004
Public Function ReturnRef(s As Worksheet, r As Range) As Strin Dim sheet As Strin Dim address As Strin sheet = s.Name & "! address = r.address(ReferenceStyle:=xlR1C1 ReturnReference = sheet & addres End Function ' Return for Example "SheetName!R1C1 Public Sub FromTakeoffToEstimate(Takeoff As Worksheet, Estimate As Worksheet) ' Drawing to Esitmat ' Setting up Equations for Estimat Estimate.Cells(9, 2).FormulaR1C1 = "= " & ReturnRef(Takeoff, Takeoff.Cells(2, 4)) .... End Su I was wondering if anyone can see a problem with this code or has another way to solve this proble |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CREATE AND IF FORMULAS | Excel Worksheet Functions | |||
create if formulas | Excel Worksheet Functions | |||
create multiple formulas in 1 cell | Excel Worksheet Functions | |||
How to create Multiple Conditional Formulas in a single cell? | Excel Discussion (Misc queries) | |||
Create macro for formulas | Excel Programming |