harlan grove

  1. N

    Pull vba from Harlan Grove - Need Code

    I have a version of the pull equation from Harlan Grove, but it is not working well. The posts I have found link to installing unwanted software, does someone have a good link or simply a copy of the vba I can get? Thanks.
  2. S

    pull function

    I am trying to use Harlan Grove's pull function but I can't get it working despite spending a good deal of time doing the research and playing with various options. That leaves me in 1 of 2 places, 1) I'm not using the latest code, or 2) there is something so obvious that my brain has stopped...
  3. J

    Simple link to external xls file

    a1: 210.xls a2: 211.xls a3: 250.xls .... an: 335.xls In my master xls file, I want to link a cell from each of the above files listed in column A. If I type (say to cell B1) =[210.xls]sheet1!$B$6 I can get the value of cell "B6" of "sheet1" of file "210.xls" Now my question: Is there a way to...
  4. E

    Harlan Grove's Pull Function

    Hello Mr. Excel et al, Mr. Excel (Bill Jelen) had a great podcast for Harlan Grove's pull function. It worked great for Excel 2003. I have not been able to get it to work in Excel 2007. Any ideas if VBA for Excel 2003 and VBA for Excel 2007 requires some sort of conversion? Thanks for a...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...