I'd like to take a stab at this, unfortunately I can't visualize the form or
what you are attempting to accomplish. I do know you will have to have
VB/Vbscript experience to accomplish it. Do you have any experience with
VB? If not that just means it will take longer to accomplish the task.
I'd like to see the Excel spreadsheet, with some dummy data showing the
bolding and none bolding information you are referring to. Once I can see
what you are referring too, I will have a better understanding of whether I
can help or not. If I can't then maybe I can point you in the right
Programmer / Analyst
Computing and Network services
From: mike kerr [mailto:mikezcg@y...]
Sent: Friday, January 25, 2002 11:38 AM
Subject: Debuging worksheet
I have an income statement in worksheet2 that uses General Ledger accounts
There are MANY G/L accounts and many lines on the Income Statement, what i
do to make sure all accounts are referenced is Set the range NOT to bold,
then dbl clk to each formula to select precedents. And check to see if any
of the precedents are bold, if none of the precedents are bold i then bold
all of them.
I would like to write a sub that would :
1) select direct precedents of a cell
2) assign the number of precedents to a variable
3) assign all the cells ranges to an array
4) Check to see if any of the precedents ARE ALREADY BOLD,
i) if so Msgbox and debug print
a) the number of precedents and
b) the address of the Bold cell and
c) what the direct dependents of that cell are.
5) If no precedents are bold msgbox "ok"
Sorry for the huge demand with any lack of code. When I use the Macro rec
and object browser and immediate window I AM LOST!!! this example would
help me GREATLY to understand excel object model.