View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
The Wonder Thing[_2_] The Wonder Thing[_2_] is offline
external usenet poster
 
Posts: 4
Default Questions of Great Import

Well... to me anyways...

O.k. First, is there a faster way to do this:

For Each c In ActiveSheet.UsedRange
If c.Formula Like "=*" Then
c.Font.Italic = True
Else
c.Font.Italic = False
End If
Next

And second, how do I do something For Each Sheet in Workbooks("This Workbook")? I've tried doing that, and it doesn't seem to be working.