last cell

  1. L

    Automatically Copy Last Cell (Most Up-to-Date) from Multiple Worksheets into a Summary Worksheet

    I have a workbook in which I keep track of various documents and where they are in the completion process. One column is for "Comments/Status," in which I state something like, "11/9/10 - Sent to Joe Q. Public for review." I will have several rows with similar information; for example, the...
  2. P

    cell position and find last <> null 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...
  3. H

    UDF for Last Cell in Range

    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...
  4. S

    Import textfile to first free cell in row and use right formating

    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...
  5. M

    Insert rows question

    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...
  6. B

    Last Used Cell Formula

    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: "...
  7. T

    Selecting 1 static cell and 1 variable cell and fill down

    <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"...
  8. J

    Finding last row - non-VBA

    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...
  9. F

    Find last row in a password protected sheet

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top