Thread: Excel Dynamic Named Ranges in multiple columns
View Single Post
  #1   Report Post  
Act17M Act17M is offline
Junior Member
  
Posts: 2
Default Excel Dynamic Named Ranges in multiple columns
I'm trying to create a Dynamic Named Range with the following formula however when I enter the formula in Name Manager the selection go down up to row 5850. It select 5 times the number on the formula.
Any help please? Thank you.

Code:
=OFFSET(dataRaw!$C$1:$G$1170,,,COUNTA(dataRaw!$C$1:$G$1170))
Reply With QuoteReply With Quote