[access-uk] Re: Eureka! Assignment solved!
- From: Chris <christopherhallsworth71@xxxxxxxxxxxxxx>
- To: Carol Pearson <access-uk@xxxxxxxxxxxxx>
- Date: Sun, 13 Jul 2008 17:26:39 +0100
Hi, it's ok Carol. Least you tried.
--
Chris Hallsworth
Please visit my blog at http://chrishallsworth.wordpress.com
You wrote:
Very glad you made it, Chris. Sorry I wasn't able to help you all the way.
--
Carol
carol.pearson29@xxxxxxxxxxxxxx
On Sunday, July 13, 2008 2:54 PM (UK time), Chris at
christopherhallsworth71@xxxxxxxxxxxxxx said:
> Hi all, first of all I'd like to thank you so much for all the help
> and support throughout my assignment so far. It has been greatly
> appreciated. Second, I at last found a way for the go to dialogue to
> display the references I need for the count function! Here's how to
> do it:
> 1. Select a range of cells.
> 2. Press control g to open the go to dialogue box.
> 3. Tab to the go to list box, and press end to highlight the
> excel_builtin_print_area. I assume this is a macro, but anyhow, press
> enter to go to that reference.
> 3. Go back up to the range of cells you've selected, and press
> control g. Now watch, as the reference(s) are filled in for you!
> What I did then was to copy what was in that edit field, go to the
> monthly_model worksheet, and in the cell I want I type the following
> into my formula: =count(share_prices!references), where references is
> the actual cell references, separated by commas. To make things
> easier, I pasted the references so that I didn't have to type it all,
> obviously. Then I ended the formula with a closing bracket ()), and I
> got the results I hope were right! Just thought I'd let you all know,
> as I know you've all been struggling to help me with this task, but
> eventually I got there. Thanks again for all the help and support,
> and please, keep them coming.
> ** To leave the list, click on the immediately-following link:-
> ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe]
> ** If this link doesn't work then send a message to:
> ** access-uk-request@xxxxxxxxxxxxx
> ** and in the Subject line type
> ** unsubscribe
> ** For other list commands such as vacation mode, click on the
> ** immediately-following link:-
> ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq]
> ** or send a message, to
> ** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq
** To leave the list, click on the immediately-following link:-
** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** access-uk-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq
** To leave the list, click on the immediately-following link:-
** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** access-uk-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq
Other related posts:
