Macro for defining a range

**studentUH** · 08-21-2008, 04:09 PM

Hello this is my first post and i am in need of help. I need to have a macro that will automaticaly create ranges. (define a range) .

I would like a macro that would look in column D and look for the section that has "2" and name that section "oldt", if "7" name new "newnt", if "8" name "newt". The last column will always be "O"

I have attached what the file i am working looks like.

Please help if you can.

Thanks

**studentUH** · 08-21-2008, 04:22 PM

can anyone solve this?

**royUK** · 08-21-2008, 04:45 PM

have some patience. Is this what you mean?

Please Login or Register  to view this content.

**royUK** · 08-21-2008, 04:50 PM

You have already been asked to read the rules, if you read them all you will see you are asked not to use unnecessary words in the title like Easy. In any case if the code is easy why ask?

**studentUH** · 08-21-2008, 05:54 PM

THANKS!! this is very close to what i need, instead of just naming the cells in column D i need it to also capture all cells to the left and right.

so for example in the file that i uploaded "newnt" would be from A10 O15

**Leith Ross** · 08-21-2008, 06:57 PM

Hello studentUH,

This is macro will create the named ranges covering columns "A to "O". Call the macro "Run" to create your ranges.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

**royUK** · 08-22-2008, 01:51 AM

Try this amended code

Please Login or Register  to view this content.

Macro for defining a range

LinkBack

Thread Tools

Rate This Thread

Display

Macro for defining a range

Thread Information

Users Browsing this Thread

Similar Threads

macro to name a certain range

Macro to PivotTable a SemiPopulated Dynamic Range

Print order for range in macro

Create Macro To Copy Moving Range of Rows

Print Range Macro "ALMOST" working.

Bookmarks

Bookmarks

Posting Permissions