HOW TO write a macro for dynamic relative named ranges in Excel?

		Microsoft Office Forums > Microsoft Excel > Excel Programming
HOW TO write a macro for dynamic relative named ranges in Excel?

FAQ

Thread Tools

Display Modes

01-24-2022, 09:27 PM

soroush.kalantari soroush.kalantari is offline

Windows 10 HOW TO write a macro for dynamic relative named ranges in Excel?

Office 2016

Competent Performer

Join Date: Jun 2021

Posts: 124

soroush.kalantari is on a distinguished road

Thank you NoSparks for your constructive response. My second problem was solved, but when I replace "=INDEX(cellAddress02:cellAddress,myrow)" with "=INDEX(" & cellAddress02 & ":" & cellAddress & "," & myrow & ")", the code encounters runtime error 1004, saying "there is a problem with this formula".

Tags

address, macro, relative named ranges

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Use of named ranges based on cell content	Intruder	Excel	12	02-25-2019 09:42 AM
Named Ranges Help	SavGDK	Excel	5	05-01-2017 09:41 AM
How to use named ranges in excel vba?	bosve73	Excel Programming	4	01-25-2012 09:26 AM
Dynamic Named Ranges using text	hannu	Excel	0	06-22-2010 04:42 PM
Can't import home adresses in outlook 2010 from excel named ranges	eekie	Outlook	0	05-14-2010 02:04 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:11 PM.