Can anyone tell me how I can change the cell color in row 1 used range for all sheets minus a sheet called summary
Can anyone tell me how I can change the cell color in row 1 used range for all sheets minus a sheet called summary
Try
Sub foo() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets If Not ws.Name = "summary" Then ws.UsedRange.Rows(1).Cells.Interior.Color = 255 Next ws End Sub
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Perfect!! Thank you so much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks