Thread: [Solved] HOW TO write a macro for dynamic relative named ranges in Excel?
View Single Post
 
Old 01-24-2022, 09:27 PM
soroush.kalantari soroush.kalantari is offline Windows 10 Office 2016
Competent Performer
  
Join Date: Jun 2021
Posts: 115
soroush.kalantari is on a distinguished road
Default
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".
Reply With Quote