Logo 
Search:

MS Office Answers

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Holly Fox   on Mar 13 In MS Office Category.

Referring to a named range in XL


  
Question Answered By: Rochelle Elliott   on Mar 13

Looks like the OFFSET() function may be using the wrong parameter delimiters
[semicolom].
Try changing:
New_rows =OFFSET(Data!$B$1;1;0;COUNT(Data!$B$2:$B$2004);4)
to this with the [comma]:
New_rows =OFFSET(Data!$B$1,1,0,COUNT(Data!$B$2:$B$2004),4)

Share: 

 

This Question has 2 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Referring to a named range in XL Or get search suggestion and latest updates.


Tagged: