Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run macro on all worksheets within workbook
I have a simple macro that highlights entire row based on specific
value within specified range. Sub RowHighlight() Dim DataRng As Range Dim LastRow As Long Dim cell As Range LastRow = Cells(Rows.Count, "A").End(xlUp).Row Set DataRng = Range("A3:A7") For Each cell In DataRng If cell.Value = " Date" Then cell.EntireRow.Interior.ColorIndex = 3 End If Next cell End Sub My workbook has more than a 100 worksheets...it would be a pain to tab through all of them and run this macro. How do I make it run through all worksheets? Any help would be greatly appreciated. Thanks, Mark |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine worksheets in multiple workbook in one workbook with a macro | Excel Discussion (Misc queries) | |||
Apply Macro to all worksheets in a workbook except one | Excel Discussion (Misc queries) | |||
Macro to paste worksheets in another workbook | Excel Discussion (Misc queries) | |||
Running Same macro in 250 Worksheets in Same Workbook | Excel Worksheet Functions | |||
Applying same macro to all worksheets in workbook | Excel Discussion (Misc queries) |