find last

  1. J

    Can you make this Code smaller, and minimize the time of execution?

    hello, can you help me with that code, i'm new with excel (you can say that, i don't know a thing about it), i just create this code by: copy and past from here and there,, without knowing excatly what it does mean.. but, he is work perfectly. now i have a small problem, the code is taking too...
  2. M

    Find last date

    Ok, this should be an easy one. I need to figure out how to get the find function to activate the last cell with the found data. The task is to find the last date in a column of dates that may have duplicates. So if you just use the find method it stops at the first cell it finds with the date...
  3. W

    Find function within macro

    Does anyone know of a way to have the excel find function work within a macro. I have got an invoice tabs and a few different revenue tabs. I plan on assigning each revenue tab a seperate set of shortcut keys. When ran, I am wanting it to lookup a value in the newly added item to the...
  4. J

    Another Thread extraction question!

    I want a formula that will take a filepath reference and yield only the filename, for example: Cell A1 contains: <TABLE style="WIDTH: 402pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=536 x:str><COLGROUP><COL style="WIDTH: 402pt; mso-width-source: userset...
  5. F

    Search for non value and move contents to a specific cell

    Thanks in advance for any suggestions! <o:p> </o:p> I have information in column B which is a list of account codes and names, with a sub-total name below the names, eg. 106432 Salaries (B3) 106772 Benefits (B4) 106882 Leave...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top