Thread: Code works within VBE but not from Excel
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SpaceCamel SpaceCamel is offline
external usenet poster
  
Posts: 15
Default Code works within VBE but not from Excel
I have code that populates a list of cells then applies formating depending
on the content. Like:

If APercent 0 And APercent < 100 Then
Worksheets("List").Range(Cells(tcnt + 4, 4), Cells(tcnt + 4,
8)).Font.ColorIndex = 10
End If

The code works fine when run from within the VB Editor. But if I run it
from Excel (menu or button) the cells are populated but the cells are not
formated. I have tested that the formatting code is being run.

Any ideas of what is going on here?
Reply With QuoteReply With Quote