Search results for query: *

Thanks so much xlhelp! If: "Height is expressed in number of rows, that you want the returned reference to be. Height has to be a positive number. Width is number of columns, that you want the returned reference to be. Width has to be a positive number. If either height or width is...

anyone know the meaning of the following function: SLOPE(OFFSET(ref,rows,col,height,width), OFFSET(ref,rows,col,height,width)) as far as calculating the slope of a curved line, what do the paramters of OFFSET stand for?

Thank you! It works very well!

Thanks a lot xlbo! That's exactly what I meant! Are you sure: rows(i&":"&i).entirerow.delete is correct? For some reason that part isn't working...

Let me clarify, I'd like to continue deleting every other row down a column until there is no more data in that column... So this list: Becomes: A A A B B C B D C E C F D...

How do continue an opertion until there is no more data? Or a specifeid number of times. I am deleting every other row, but I need it to continue for at leaast 100s of rows long: ' Keyboard Shortcut: Ctrl+w ' Selection.EntireRow.Delete Range("A2").Select...

If I deleted the data, there'd still be a blank row remaining right? If so, the row. My goal is to get rid of the data, but I don't want empty rows remaining...

If I deleted the data, there'd still be a blank row remaining right? If so, the row.

How do I delete every other row in excel until there is no more data in the cells, or from 1 to 1000?

Is there a forum such as this for S-PLus?

Help! I am trying to divide a list of data entries separated by a space into their own text documents one file: A B C //changing this to three files: file 1 file 2 file 3 A B C

I am trying to match a list with another list. They both have the same values but in a different order. I am having a problem with the find command, it keeps finding and matching the same text 'ABCD' as opposed to matching the string in the next cell 'ABCD'. 'EFGH', 'IJKL'. How do I assign a...

Hiya! I'm a newbie! I have four columns of data: number1 label1 number2 label2 the label have the same values, but different numbers assigned to them. I am trying to take each sequential number1/label1 combination, paste it into the next row, find the same matching string in label 2, cut and...