Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-09-2024, 04:57 AM
p45cal's Avatar
p45cal p45cal is offline How to select nonadjacent difiened names at once? Windows 10 How to select nonadjacent difiened names at once? Office 2021
Expert
 
Join Date: Apr 2014
Posts: 947
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

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
or perhaps
Code:
  Set rng = Selection
  Set rng0 = Range("range1")

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

Reply With Quote
  #2  
Old 01-09-2024, 08:19 PM
soroush.kalantari soroush.kalantari is offline How to select nonadjacent difiened names at once? Windows 10 How to select nonadjacent difiened names at once? Office 2021
Competent Performer
How to select nonadjacent difiened names at once?
 
Join Date: Jun 2021
Posts: 124
soroush.kalantari is on a distinguished road
Default

Quote:
Originally Posted by p45cal View Post
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.
Reply With Quote
Reply

Tags
defined name, select



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to select nonadjacent difiened names at once? 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
How to select nonadjacent difiened names at once? 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 03:14 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft