data range

Once I have named a data range, if I want to add to, delete from or rename the range, how do I do that?

Hi, Hopefully someone can help with my question. I am creating a chart in Excel. The data from the chart will be based on a selected range (ex. A1:G1). Not every cell will always have data. How do I set it up so that the times where no data is entered, it does not default to $0, which then...

I have a range of data which is repeated after a break in row X. I need help setting up a VBA macro to select the top range of data and remove it. This is exported data from another programme and one worksheet contains both "pre" and "post" data for the same data set, displayed as mentioned...

Hi Guys, Would love a wee hand with this: My data looks like this A B 1 0 1 1 1 2 1 0 2 4 2 4 2 0 2 5 3 1 3 5 3 0 3 2 3 4 What i want to do is that for each value in A, count the number of occurrences of values 1:5 in it's matched rows. Ideally i want to do something like this but i can't get...

I am running XL 08 chart based on 3 columns of data: ****** http-equiv="Content-Type" content="text/html; charset=utf-8"> ****** name="ProgId" content="Excel.Sheet"> ****** name="Generator" content="Microsoft Excel 2008"> <link id="Main-File" rel="Main-File"...

hi This is Aatish I am facing a problem in MR Excel 2007 in copying a huge data from a sheet. details are as below: i have a data of size Nx2845 in a single sheet of a workbook. i applied some filter on the header and tried to copy the filtered data into a new sheet and got this error For...