named cell range

**zak.horrocks** · 10-02-2014, 09:22 AM

Is it possible to name a cell range but only include cells that contain specific text i.e.

My named range would be Dave and the cells in this range would be all the Daves in the list below

Dave Jones
Bill Burke
David Smith

Is that possible? Many thanks

Zak

**6StringJazzer** · 10-02-2014, 11:05 AM

There are a few steps you could go through to do this manually as a one-time process, but it would be static--it wouldn't stay up to date when your data changes.

Do a Find All on the string you want to match (in your case you only have one Dave; you wouldn't match David)
Select all from the list of found cells
Go to Formulas, Name Manager and create New
The formula bar will contain the list of cells that are selected
Give it a name and save

It would be possible to implement a dynamic version using VBA.

**zak.horrocks** · 10-03-2014, 03:15 AM

The list will eventually contain hundreds of Dave's and will continue to grow, is it possible to get some help with the VBA code?

Thanks

Zak

named cell range

LinkBack

Thread Tools

Rate This Thread

Display

named cell range

Re: named cell range

Re: named cell range

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] determining if cell is part of named range and what that named range is

[SOLVED] Determining if the value of a cell can be a named range, then assigning named ranges after

[SOLVED] Determine what Named Range the Target Address is and return Named Range Name

inserting a named range into new cells based on a named cell

If any cell in named range = 8 then shade named range

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions