Thread
:
my workbook reference is not working
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
my workbook reference is not working
Could it be Trending Source vs Trend Source?
It appears that you are referring to:
a workbook named Trend Source
a worksheet named Stats
BTW you don't need all this selecting
Worksheets("Data (altered)").Range("F14").FormulaR1C1 = _
"=LOOKUP(df,[Trend source.xls]Stats!R1C4:R34C4, [Trend
source.xls]Stats!R1C5:R34C5)"
--
Don Guillett
SalesAid Software
"Papa Jonah" wrote in message
...
I have a workbook that uses a macro to copy itself, save it to another
file,
then populates sheets with formulas and such. Everything works great
until a
look up statement.
Below, I have pasted the troubling code in the macro. The referenced
sheet,
"Trending Source" is the original workbook that was copied and is still
open.
Dim myrange As Range
Dim mysheet As Worksheet
Worksheets("Data (altered)").Select
Range("F14").Select
' Set myrange = Range("f14")
' Set mysheet = Worksheets("Data (altered)")
Range("F14").Select
'run time error 1004 occurs in following statement
ActiveCell.FormulaR1C1 = _
"=LOOKUP(df,[Trend source.xls]Stats!R1C4:R34C4,
[Trend source.xls]Stats!R1C5:R34C5)"
Range("F15").Select . . .
Any ideas? TIA
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]