Macro Performed on Selected Range

eviljamk55 · May 6th, 2002, 12:18 PM

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 · May 6th, 2002, 12:47 PM

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 · May 6th, 2002, 12:52 PM

thank you very much. I will give it a try

May 6th, 2002, 12:47 PM	#2
Ricky Morris Board Regular Join Date: Mar 2002 Posts: 363	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 __________________ It's never too late to learn something new. Ricky

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 6th, 2002, 12:18 PM	#1
eviljamk55 New Member Join Date: May 2002 Location: Home Posts: 6	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!

May 6th, 2002, 12:52 PM	#3
eviljamk55 New Member Join Date: May 2002 Location: Home Posts: 6	thank you very much. I will give it a try