execute operation with a selection

firuz

New Member
Joined
Mar 18, 2002
Messages
7
I wanna be able to select some cells, and then execute some operation regarding each cell in the selection for example set each cell content uppercase. I manage to write a code for setting any activecell content as uppercase, but fail to do it for a selection.
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
Try the following code by putting it in the code for your worksheet:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$F$4:$G$4" Then
Target.Value = UCase(Target.Text)
End If
End Sub

Subsitute "$F$4:$G$4" with your range, formatted the same way.
 
Upvote 0
Thanx Juan Pablo,

It helped me for 100%. I'am not professional in programming, so I ve been searching for this facility for several months. :)
 
Upvote 0

Forum statistics

Threads
1,213,532
Messages
6,114,177
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top