Erros when printing from a Validation list

[Wray69]

I am trying to print each change in a validation list by using the following code;

Sub Print_all()
ActiveSheet.PrintOut
For Each c In Range("names")
    [J5] = Change.Value
ActiveSheet.PrintOut
Next
End Sub

When I attempt to run the code I am getting the following errors;

un-time error 1004 application defined or object defined error

or

method range of object worksheet failed

Anyone have any ideas?

Thanks,

Wray

 

[SkipVought]

Hi

This looks like VBA in Excel. You should be in forum707.

Sub Print_all()
ActiveSheet.PrintOut
For Each c In Range("names")
    [J5] = [red][b]C[/b][/red].Value
ActiveSheet.PrintOut
Next
End Sub

Skip,
[sub]
[red][/red]
[/sub]

 

[Wray69]

Oops, thanks Skip. Clicked on the Wrong forum. and I had that as a "C" and not Change, just typed it in here wrong.

Thanks,

Wray

 

[SkipVought]

So is there still a problem?

Skip,
[sub]
[red][/red]
[/sub]

 

[Wray69]

Yeah, I still have the problem Skip....