Application-defined or Object-defined error

  • Thread starter Thread starter noll2
  • Start date Start date
N

noll2

How do I fix the "Application-defined or Object-defined error" at the
"Activecell.Formula =" line?


nrow = Sheets("Data Entry").Range("A8").Value
Z = 11
mycell = "B" & Z
Range("A1").Select
Range("A1:J10").Copy
For I = 1 To nrow
ActiveCell.Offset(10, 0).Select
ActiveSheet.Paste
Next I
Range("c15").Select
For I = 1 To nrow
ActiveCell.Formula = "=+'Data Entry'![" & mycell & "]"
Z = Z + 1
mycell = "B" & Z
ActiveCell.Offset(10, 0).Select
Next I
 
Does this fix it?

ActiveCell.Formula = "='Data Entry'!" & mycell & ""


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run-time error 1004 8
Combine three InputBoxes into one? 7
Help with Index formula 2
looping programme require 16
Help with Exiting Sub if Value is Not Found 5
Run-time error 1004 paste method of worksheet class failed 3
Import Word Table Macro running very slow 13
Application-defined or object-defined error 2

Back
Top