ExcelBanter - Run-time 1004 error

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Run-time 1004 error (https://www.excelbanter.com/excel-programming/428550-run-time-1004-error.html)

Kent McPherson[_2_]

Run-time 1004 error

I have the following code snipet in module1 in Excel 2003:

temp = "C" & LTrim(Str(i))
labor_detail = Worksheets("Labor $").Range("temp").Value

When the code runs, temp is correctly set. e.g C2. But when the 2nd line
runs, I get the Run-Time error 1004, Application-defined or object-defined
error message.

What am I missing?

All times are GMT +1. The time now is 06:29 AM.