Setting source data for chart

[m.hatter]

Hopefully, there is a really obvious problem here, but I cannot make this thing fly. Can you see what is wrong?

Background:
Data is on sheet2. A chart for the data already exists on Sheet3. I am trying to skim down column 3 (column C) on Sheet2 and take only the last 12 data points and use them for the source data for the chart on Sheet3.

One possible clue is that the original chart had 2 sets of data...one for the numbers and one that was a column of month names for the Y -axis. I am not sure that should make this code illegal though. Anyway, thanks in advance for the help.
m.hatter

Please Login or Register  to view this content.

[m.hatter]

OK...after this many looks and no comments, maybe the question is not very clear.

Another example:

Lets say you have a set of numbers of unknown size all listed in column A of sheet1 of your workbook. How would you create a range object with a value equal to the last 12 used cells in column A?

I know that counta can be used to figure out which was the last used row in the column, but how to you convert (say) 52 (where 52 is the last used row) to a range equal to something like Range("A40" , "A52").

I have been trying to use the Cell syntax (which seems a lot more variable friendly) but I cannot make it work. Any help or pointers in the right direction would be greatly appreciated.

Thanks.

[blane245]

How about this? I think you may be misusing the CountA function.

Please Login or Register  to view this content.

mRange is this the range that you are interested in.

[m.hatter]

All praise to blane245!!!! It worked!!

Thanks a lot!!! This has been the maddest I have been at a computer in a long time. I thought I had advanced beyond such noobisms.

I am extremely new to Excel, .end and .address and pretty friggin' handy. Hard to ask about something you have never seen before. Thanks again.!

Now on to other chart problems!


m.hatter