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