Refer to data that has been named - define | Excel forum

Resolved · Low Priority · Version Standard

Fri 15 Feb 2008, 13:39 Delegate Rebecca said...

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

Sun 17 Feb 2008, 15:00 Edited on Sun 17 Feb 2008, 15:01 Trainer Stephen said...

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

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Use the Format Painter to copy formatting more than once in Excel

The format painter tool provides a quick and easy way to copy formatting from one cell to another in Word.

The only problem is that if you click the Format Painter once to turn it on, you can only click and drag over a single cell or adjacent range of cells; then the Format Painter turns itself off automatically.

If you want to copy formatting to cells or groups of cells that are not adjacent to each other, double-click the Format Painter - this way you will be able to copy formatting to multiple cells.

When you have finished using Format Painter, press the Esc key or click on the Format Painter button once to turn it off.

View all Excel hints and tips