Want to run the same macro on multiple worksheets without referencing the sheet name

[kerrya98]

I found the following snip of code from another website and it is working for two portions of my macro. The first works to change all "?" to 0 and then the second part works to take the contents of cell A4 and paste in column L. I am having problems getting the rest of the macro to work.
Any suggestions would be appreciated! Thank you!!

Please Login or Register  to view this content.

[Hurricanefly]

Just having a quick look. It looks like column K:K is a % and it is formatting that with a colour if its a %. Not sure why the last part is not working? How many worksheets do you have? It should add the values to F1, which is (6,1)

[kerrya98]

Thanks for taking a look!

Yes, K:K is a % and we are looking to say if the value in K<-0.05 or if the value in K>0.05 then color. This isn't working on multiple sheets.

For the last portion, all of my data starts in row 9, and I would like to format the titles in row 6

Both of these are not currently running on my sheets. In total I have 32 worksheets in the workbook.