[access-uk] Re: May be getting somewhere, but have a question on go to dialogue in Excel 2003
- From: Chris <christopherhallsworth71@xxxxxxxxxxxxxx>
- To: Carol Pearson <access-uk@xxxxxxxxxxxxx>
- Date: Fri, 11 Jul 2008 18:27:11 +0100
Hi, not quite. I highlighted the cells *before* opening the go to dialogue box,
and somehow the references were there so I could, in this case, copy them to
the clipboard and use them as part of my formula. I just don't know why I can't
duplicate this for the other references I want to use.
--
Chris Hallsworth
Please visit my blog at http://chrishallsworth.wordpress.com
You wrote:
If you're talking about the Goto command, type CTRL+G followed by the
cells/rows you want to highlight.
EG: CTRL+G A6:A10
(Note the colon separating the start and end point.)
I hope I've understood your question correctly.
--
Carol
carol.pearson29@xxxxxxxxxxxxxx
On Thursday, July 10, 2008 7:15 PM (UK time), Chris at
christopherhallsworth71@xxxxxxxxxxxxxx said:
> Hi all, well I may be getting somewhere with this assignment. I
> managed to somehow get the go to dialogue in Excel 2003 display the
> ranges for the first month, and for now the value came out to 22.
> However, I can't remember how I got the go to dialogue to display the
> ranges in the first place! Does anyone know what I may have done so
> that I can remember how to do it for the rest of the months? Many
> thanks in advance.
** 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:
