LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 210
Default multiple column dynamic range

I have a range from C2:D234. The column C has a heading of term and Column D
is the abbreviaton. I want the cells starting wiht C235 and D 235 to be able
to have additions made by the user. I have been given instructions to do the
following

have 2007 version and I have gone to Formulas tab and then select name
define
Then I type in DynAbbrMeasure
I select list (is there something else that I should select?)
I then Paste =OFFSET(Measure!$C$2,0,0,COUNTA(Measure!$C:$C),2)
Click ok
Press F5
In the go to box it states D236:D236
I type in DynAbbrMeasure
It states that the Reference is not valid

What am I doing wrong? The end of the typed list is C 234 & D 234 and I
would like the range to be added to and an indefinite range. I would
appreciate your help with this.

Sincerely,

Robin


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamic Range for multiple columns Robin Excel Discussion (Misc queries) 8 April 3rd 23 02:26 PM
Formula to count every other column (dynamic range) Darlene New Users to Excel 7 November 18th 08 09:27 PM
Dynamic range using partial column? Donal P[_2_] Excel Discussion (Misc queries) 1 August 15th 07 10:00 PM
Dynamic range names, multiple criteria, sumproduct [email protected] Excel Discussion (Misc queries) 1 September 20th 05 02:58 AM
Dynamic named range across multiple sheets babycody Excel Discussion (Misc queries) 3 July 24th 05 06:03 AM


All times are GMT +1. The time now is 02:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"