Posted to microsoft.public.excel.programming

SpaceCamel SpaceCamel is offline

external usenet poster

Posts: 15

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VB6 Excel 97 code no longer works if Win2K SP3/4 applied.	Tim R[_3_]	Excel Programming	5	October 10th 04 06:24 AM
Code works with Excel 2000 but not with Excel 2002	La Durande	Excel Programming	0	September 17th 04 09:46 PM
Code works with Excel 2000 but not with Excel 2002	Tom Ogilvy	Excel Programming	0	September 17th 04 09:21 PM
Code works with Excel 2000 but not with Excel 2002	La Durande	Excel Programming	0	September 17th 04 08:49 PM
code works in excel 2002, but not in excel 2003	pyc	Excel Programming	2	September 2nd 04 01:16 PM

All times are GMT +1. The time now is 08:58 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us