How to select nonadjacent difiened names at once?

		Microsoft Office Forums > Microsoft Excel > Excel Programming
How to select nonadjacent difiened names at once?

FAQ

Mark Forums Read

Thread Tools

Display Modes

01-09-2024, 08:19 PM

soroush.kalantari soroush.kalantari is offline

Windows 10 How to select nonadjacent difiened names at once?

Office 2021

Competent Performer

Join Date: Jun 2021

Posts: 124

soroush.kalantari is on a distinguished road

Quote:

Originally Posted by p45cal

likewise not sure but maybe

Code:

  Set rng = Selection
  Set rng0 = Range("range1")

  For i = 2 To 100
    Set rng0 = Union(rng0, Range("range" & i))
  Next i
 
  Union(rng, rng0).Select

@p45cal .Thank you very much. First code solved the problem.

Tags

defined name, select

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Removing microsoft build-in style names - display of style names in styles gallery changed	Firebody	Word	8	03-06-2022 08:22 AM
Select entire text and then de-select certain Headings?	tq94	Word	3	02-26-2022 03:47 AM
Address sheet - I have an address sheet, I want to create and add names from a database of names.	moscowamerican	Mail Merge	1	09-12-2020 07:31 AM
matching names in column A with names in column C	bob999999	Excel	1	04-28-2013 11:21 AM
How to enter names in Resource Pool/names	pstein	Project	1	03-26-2012 07:37 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:16 PM.