Macro Performed on Selected Range

[eviljamk55]

what is the proper syntax to perform the following in an Excel Macro:

"For Each Cell in the selected range do this"

thanks in advance!

 

[Ricky Morris]

The following example will make the value of each cell in a selection 1.

Sub Macro1()
For Each cell In Selection
cell.Value = 1
Next
End Sub

 

[eviljamk55]

thank you very much. I will give it a try