Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

refer data has been

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Refer to data that has been named - define

Refer to data that has been named - define

ResolvedVersion Standard

Rebecca has attended:
Excel Advanced course

Refer to data that has been named - define

I have a large file that has been segmented into areas that are given specific names. (In this case each section is divided into months.)

I have defined the names by going into Insert, Name, Define. I am now writing a code that refers to column 5 in each segmented month. I am trying to refer to the range by the Name i have inserted and then by offseting to column 5, however I cannot seem to write the code correctly

Can you help

Many thanks

Becky

Edited on Sun 17 Feb 2008, 15:01

RE: Refer to data that has been named - define

Hi Rebecca

Thank you for your question

There are a number of approaches here, depending on what you want to achieve although in general they all use the cells property of the range object

1. To select the column header cell

Range("Sales").Cells(1, 5).Select


The above code selects the cell on the first row and fifth column of the range

 

Training courses

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Currency format

Ctrl+Shift+$ applies the Currency format, with two decimal places

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.