Macro auto fill is not workin

[Ashkan2016]

Hi all
I am trying to write for my excel .I am begginer and this first time I tred Macro.
I wrote this code
<code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit;">

Private Sub Worksheet_Change(ByVal Target As Range)
If Application.Worksheets("1").Range("D2").Value = "Completed" Then
      Worksheets("2").Range("C26").Value = Date
   Else
      Worksheets("2").Range("C26").Value = ""
End If
If Application.Worksheets("1").Range("E2").Value = "Completed" Then
      Worksheets("2").Range("D26").Value = Date
   Else
      Worksheets("2").Range("D26").Value = ""
End If
If Application.Worksheets("1").Range("D3").Value = "Completed" Then
      Worksheets("2").Range("C27").Value = Date
   Else
      Worksheets("2").Range("C27").Value = ""
End If
If Application.Worksheets("1").Range("E3").Value = "Completed" Then
      Worksheets("2").Range("D27").Value = Date
   Else
      Worksheets("2").Range("D27").Value = ""
End If
Worksheets("2").Range("C26:D27").Select
Selection.autofill Destination:=Worksheets("2").Range("C26:ZZ52")
End Sub

error 1004;Select method of rang class failed and the line
Worksheets("2").Range("C26:D27").Select
is highlighted
I have no idea what to do ;can you guys help me thanks

Ashkan
Email:rezania.ashkan@gmail.com

</code>

 

[My Aswer Is This]

Selecting and using Autofill will not work that way.
You need to come up with another way of doing this or explain what your wanting to do and maybe I can provide another solution.

 

[My Aswer Is This]

And with your sheet change event setup like this with no criteria every time you make any change anywhere on your sheet this event is going to be activated. Which is probable not a good plan.

Since you really did not ask for any help other then the problem with Autofill. I will leave any more comments to a later date if you care to tell us what your trying to do here.

 

[Ashkan2016]

And with your sheet change event setup like this with no criteria every time you make any change anywhere on your sheet this event is going to be activated. Which is probable not a good plan.

Since you really did not ask for any help other then the problem with Autofill. I will leave any more comments to a later date if you care to tell us what your trying to do here.

My manager asked me to make excel file for safty tracking.every one after completing training should be able to go to excel file and record the date of completion .since some people don't know computer very well the fill should give them the option between complete and not complete and if they choose complete the file should record the date.if you can send me your email address I can send you the file. I really appreciate if you help me.I am open to any suggestion and help.

 

[My Aswer Is This]

Mr. Excel discourages us from helping people outside of this Forum.
I'm not able to provide you with email address.

Please try to explain in words what your wanting to do.

If the student enters complete into what cell then what cell should be filled in with the date.
And what is the trend. For example is it always one row down or over one row.

And what is this Autofill portion of the script attempting to do.

 

[Ashkan2016]

Mr. Excel discourages us from helping people outside of this Forum.
I'm not able to provide you with email address.

Please try to explain in words what your wanting to do.

If the student enters complete into what cell then what cell should be filled in with the date.
And what is the trend. For example is it always one row down or over one row.

And what is this Auto fill portion of the script attempting to do.

I attached picture of my file.

 

[Ashkan2016]

https://www.dropbox.com/s/109rs7xkwk9jndy/Sheet1.PNG?dl=0
https://www.dropbox.com/s/ketow6g7hg51q92/Sheet%20structure.PNG?dl=0
https://www.dropbox.com/s/wjgxj0s2hmedd6w/sheet graph.PNG?dl=0
https://www.dropbox.com/s/ketow6g7hg51q92/Sheet structure.PNG?dl=0

 

[MARK858]

...and a couple of links this question is cross-posted to...

Macro auto fill is not working-EF
Macro auto fill is not working-CCM

 

[Ashkan2016]

...and a couple of links this question is cross-posted to...

Macro auto fill is not working-EF
Macro auto fill is not working-CCM

sorry about that i didnot we can post just on one frume.I make sure it wont happen again.

can you explain me more by copying?

 

[MARK858]

If you read the rules in the forums you have cross-posted in you would know that in most (including this one) allow posting in other forums but you need to post a link to your cross-posts.

There are links to this forums rules and guidelines in my signature block below (Rule 13 is relevant to this and there is a link in that rule explaining the reasons in detail)