Run-Time error 422

[olevia]

Hi Forum,

Everytime I run my code I get a Run-time error 424, I believe something is wrong with the variable cl.Row, but I can't fix it. Can anyone help. Thanks in advance. Please code below.

Sub M_snb()
   Sheets("Template").Copy , Sheets(Sheets.Count)
   Sheets(Sheets.Count).Name = "Result"
   Sheets("Template").Visible = False
   With Sheets("Result")
      .Range("B9") = InputBox("Provider's MA Number")
      .Range("B10") = InputBox("Provider's Agency")
      .Range("B11") = InputBox("Provider's Address")
      .Range("K9") = InputBox("Program Specialist")
      .Range("K11") = InputBox("Contact E-Mail")
      .Range("O10") = InputBox("Monitoring Dates")
      For j = 1 To Application.CountIf(Sheets("ACW-Participant").Columns("FE"), "UNMET")
         If j > 1 Then .Range("A1:R45").Copy .Cells(j * 50, 1)
         Set c00 = Application.InputBox("Select the range you want to copy from", Type:=8)
         If Not c00 Is Nothing Then c00.Copy .Range("E15")
         .Range("E12") = Sheets("ACW-Participant").Cells(cl.Row, 5).Value
         .Range("E14") = Sheets("ACW-Participant").Cells(cl.Row, 1).Value
      Next
   End With
End Sub

 

[Andrew Poulsom]

Re: Code is not copying correct cells

As I said before I don't see any mention of those words (LOVE, SUNSHINE etc) or worksheet (ACW) or target cells in your code.

 

[olevia]

Re: Code is not copying correct cells

I'm sorry, Andrew, please see link to the Macro example attachment. I am so frustrated and I do apologize if I was acting like an idiot, but I been working on this for a while now and this is the only problem I'm having. Once again please forgive me. Thanks again.

http://www.excelforum.com/excel-prog...html?p=3174753

 

[RoryA]

Re: Code is not copying correct cells

That link doesn't work - having seen what you posted over there I can't say I'm surprised it got deleted! (I strongly suggest you don't repeat that behaviour here)

 

[olevia]

Re: Code is not copying correct cells

What ever happen to freedom of speech or expression. I ask for help and I was brushed off. Just because a person knows how to do something shouldn't make them ignorant to others seeking help. All I wanted was help, but I got arrogant geeks trying to impress someone instead of giving the solution and then showing how it was done. I don't treat people like that in my profession because I am not above no one.

 

[RoryA]

Re: Code is not copying correct cells

Public forums don't usually allow language like that - freedom of speech doesn't extend that far!

 

[olevia]

Re: Code is not copying correct cells

You are right RoryA and I apologize. I was just a little frustrated. I will try to find another way to link my attachment. I appreciate the help you and Andrew have given me. Thank you for allowing me to post.