How to select nonadjacent difiened names at once?

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

01-09-2024, 04:11 AM

Guessed

Windows 10 How to select nonadjacent difiened names at once?

Office 2016

Expert

Join Date: Mar 2010

Location: Canberra/Melbourne Australia

Posts: 4,159

I'm not sure on the purpose of this macro but your loop might work with

Code:

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

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Tags

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 07:13 AM.