Abegail0203
New Member
- Joined
- Mar 6, 2022
- Messages
- 13
- Office Version
- 2010
- Platform
- Windows
Hello,
I have a macro that runs only in a sheet. I want your assistance to have the macro to run on all files in a folder.
This is my current macro:
Sub yellow()
Range("a1:z500").Select
For Each Cell In Selection
If Cell.Interior.Color = Excel.XlRgbColor.rgbYellow Then
Cell.Clear
End If
Next
End Sub
The macro will remove/clear all values in a cell highlighted in yellow.
I would like to run a macro that will do it for all the files in a specific folder in one single click.
Thank you.
I have a macro that runs only in a sheet. I want your assistance to have the macro to run on all files in a folder.
This is my current macro:
Sub yellow()
Range("a1:z500").Select
For Each Cell In Selection
If Cell.Interior.Color = Excel.XlRgbColor.rgbYellow Then
Cell.Clear
End If
Next
End Sub
The macro will remove/clear all values in a cell highlighted in yellow.
I would like to run a macro that will do it for all the files in a specific folder in one single click.
Thank you.