Not sure about what you're doing or how you're going about it,
but for the answers to the questions you've asked
Quote:
|
1.VBA consider parameters of my macro as text not value (for example, VBA considers cellAddress02 as “cellAddress02” not $A$1 which is what I expect)
|
the variables cannot be within quotes
Code:
"=INDEX(cellAddress02:cellAddress,myrow)"
'should be
"=INDEX(" & cellAddress02 & ":" & cellAddress & "," & myrow & ")"
Quote:
|
2.For making my named ranges relative rather than absolute, I need a VBA function to give a cell address which doesn't have $ signs before the letter (for example, I want A$1 not $A$1)
|
use
Code:
cellAddress = cell.Parent.Name & "!" & cell.address(1,0)
01-24-2022, 01:51 PM
Similar Threads
Named Ranges Help
Windows 10 
Office 2010
Threaded Mode