Scatter Brain!

[ncook12]

I have had problems with a particular spreadsheet i have been developing using VBA. I have had lots of help.
I was advised to go to Insert>Name>Define to name the title of the column. Then in 'refer to' i was given a line of code to enter - but i can't find it anywhere. It was because the range is to refer to a dynamic data range.Can anyone help? Please!

 

[SkipVought]

ncook,

Need to know what you intend to define with the name.

You can use the OFFSET function.

To name the range UNDER the heading...

=offset(

then click the cell under the heading...

=offset(Sheet1!$A$2

I clicked on A2. then continue with the COUNTA function...

=offset(Sheet1!$A$2,0,0,counta(

then click on the COLUMN...

=offset(Sheet1!$A$2,0,0,counta(Sheet1!$A:$A

and then finish...

=offset(Sheet1!$A$2,0,0,counta(Sheet1!$A:$A)-1,1)

What this does is takes the A2 reference and creates a range, as long as COUNTA and 1 column wide.

Hope this helps

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com