last cell

hello all. I would like some help about a problem i am faceing. (I am using excel 2003) . First of all ,i have this worksheet : i have several people (colA) - who are paying in 3 different methods (pay1-pay2-pay3) - each person pays several times in a year (pay method can be anything) I am...

Help! I need a UDF which encorporates the xlUp or alternative that finds the last cell in a range. The range contains formula's and the methods that I have been using give me the result of the last cell with a formula in it rather than the last cell with text or a value in it. I have used...

Hello Hopefully you can help me with this. I have tried several VBA modules made by others but I havent got it 100% right yet. Here is what I want to do. I want to import a textfile into a sheet that already contains a lot of info. I want to find the last cell in A row and there import my...

I have a spreadsheet that contains a table. In column C There is either a Y or an N. I have some code that deletes all the Y's and blank rows. I now need to insert 100 rows starting from the last row containing an N in column C. The code i have so far inserts 100 rows but inserts it ahead of...

I'm looking for a formula to return the address of the last used cell in the same workbook but on a different sheet: So I have a summary tab and nine other tabs, all data in the nine tabs are in column A. As an example, in the 9th tab the last used cell is A28; which shows: "...

<meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="ProgId" content="Word.Document"><meta name="Generator" content="Microsoft Word 12"><meta name="Originator" content="Microsoft Word 12"><link rel="File-List"...

Sorry for such a trivial question, but I want to define a named range without using VBA that embraces all used cells in a specified column. Unused cells between two used cells should be included in the range. Ie it should be a single continuous range starting with the first used cell in the...

Hello, I'm at my wit's end trying to figure this one out. I'm working on a macro that opens Excel files and finds the last row. The purpose is to find files that were saved with unused rows causing wasted space. I've been using ActiveCell.SpecialCells(xlLastCell).Row to find the last row...