Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why doesn't this color set work?
"It" is set it = activesheet (just so I have a short form). Later in my code
there are these two lines: it.Cells(i, 13).AddComment "OK" it.Cells(i, 13).Interior.Color = 13434828 the first one works fine, the second one gives an "application error" and exits. I use similar code all over my apps. What is wrong with this example? Maury |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why doesn't this color set work?
Can't see anything, works fine for me. What code do you have before it?
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Maury Markowitz" wrote in message ... "It" is set it = activesheet (just so I have a short form). Later in my code there are these two lines: it.Cells(i, 13).AddComment "OK" it.Cells(i, 13).Interior.Color = 13434828 the first one works fine, the second one gives an "application error" and exits. I use similar code all over my apps. What is wrong with this example? Maury |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why doesn't this color set work?
The second line worked ok for me.
Any chance you've protected that worksheet (allowing objects/comments to be updated)? Maury Markowitz wrote: "It" is set it = activesheet (just so I have a short form). Later in my code there are these two lines: it.Cells(i, 13).AddComment "OK" it.Cells(i, 13).Interior.Color = 13434828 the first one works fine, the second one gives an "application error" and exits. I use similar code all over my apps. What is wrong with this example? Maury -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why doesn't this color set work?
"Dave Peterson" wrote:
The second line worked ok for me. Urrrg. Ok, thanks for trying guys, I guess it's just one of those mysteries. No, there's no protection or anything, and you get the generic "application defined error" (thanks MS!) Maury |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why doesn't this color set work?
No, works fine for me, XL2K.
You're not trying to run it on a cell that already has a comment, are you ? Or i is not a valid row ? NickHK "Maury Markowitz" wrote in message ... "Dave Peterson" wrote: The second line worked ok for me. Urrrg. Ok, thanks for trying guys, I guess it's just one of those mysteries. No, there's no protection or anything, and you get the generic "application defined error" (thanks MS!) Maury |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill color and font color icons do not work in excel | Excel Discussion (Misc queries) | |||
Unable to add color to work sheet. | New Users to Excel | |||
Fill color doesn't work although font color does. | Excel Worksheet Functions | |||
My fill color and font color do not work in Excel Std Edition 2003 | Excel Discussion (Misc queries) | |||
fill color doesn't work | Excel Worksheet Functions |