Search:

Type: Posts; User: Rekd; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    99
    Views
    5,991

    Re: How to help first-time posters

    :rofl: Um, no. Just trying to help and there's no need to get testy.

    I'm basing it on my experience over the last 7 years of building up CNCzone from nothing to something the size of MrExcel...
  2. Replies
    99
    Views
    5,991

    Re: How to help first-time posters

    That wasn't my intention. I'm an admin for a forum called CNCzone, which has slightly more users than Mr. Excel so I was just equating my experience. My intention was that there's too much traffic to...
  3. Replies
    99
    Views
    5,991

    Re: How to help first-time posters

    To be honest, I don't think the new users are going to read that.

    I think the best way to deal with this very common problem is to create a little script to check the number of posts a user has;...
  4. Thread: Notices

    by Rekd
    Replies
    2
    Views
    1,359

    Notices

    Is there a way to turn these off?

    I've read it several times and it never changes. I think I've got it memorized now. :laugh:


    Notices
    Welcome to MrExcel, Rekd.
    You can post a new...
  5. Replies
    2
    Views
    445

    Re: have 12 .xls files, need to combine them

    This should work. I got the core code from here and abandoned it before getting it dialed in, but it should do what you want with minor modifications (to filename and path).


    Sub CopyAllBooks() ...
  6. Re: How to see VBA code being built while recording a macro?

    Try opening XL, then open the VB editor, then click record, then OK, then click on the new module that was created and open it, start making changes and watch the magic. :biggrin:
  7. Replies
    3
    Views
    267

    Re: Writing to a text file

    Does the macro not run? Does the macro run but not do anything? Does the macro give any errors? What happens when you step through the macro?

    I copied it to a module and it worked fine.

    Are...
  8. Replies
    3
    Views
    313

    Re: Formula from Table of Values

    Alan,

    Thanks for the link, I will study it as soon as I'm done convincing myself this will probably not be accurate enough for my reports.

    You got me to thinking: A straight slope would be...
  9. Replies
    3
    Views
    313

    Formula from Table of Values

    If I have a table of 3 quantities and 3 prices can I extrapolate a formula to calculate any quantity?

    For example, I have Part A that I can buy 50 for $5.10, 100 for $4.80 and 150 for $4.10. I...
  10. Re: Excel Doesnt Recognize Last Used Cell (How to Delete Blank Rows at Bottom of Sheet)

    I deleted everything below and saved it, but never exited and started it back up. That did it. Thanks!:biggrin:
  11. Excel Doesnt Recognize Last Used Cell (How to Delete Blank Rows at Bottom of Sheet)

    I've searched through threads back to 2005 and couldn't find the answer without downloading a plug-in like ASAP Utilities (which I cannot do due to work restrictions). (Marc's thread about "all I did...
  12. Replies
    3
    Views
    671

    Re: Green triangle headache.

    Also, if the numbers begin with zero Excel may trim them.

    If you have problems converting, enter a "1" into a cell, copy it, select all the cells with the vendor numbers, right click/paste...
  13. Replies
    2
    Views
    255

    Re: Problem with macro written for Excel 2003

    I don't think you can run Excel 2k3 macros in Excel 97. ;)
  14. Re: Automatically create Hyperlinks based upon links

    Yes. But it's hard to help without knowing what/how you're doing it. I'd start by recording a macro, performing the tasks, then edit macro to work the way you want.
  15. Replies
    11
    Views
    1,335

    Re: HELP - Job at stake !

    Lots of viable solutions here. Have you tried one?

    To be honest I'm not sure why you are at risk of being fired for something you say is not your job. If all else fails, try...
  16. Replies
    3
    Views
    392

    Re: Customized Toolbar Button

    Not sure about selecting the templates, but to simply open a folder use:


    RetVal = Shell("explorer.exe " & strNewDir, vbNormalFocus)

    If by open a folder you mean a file dialog box, that's...
  17. Replies
    7
    Views
    485

    Re: Stop any other program while running VBA?

    Another option is an actual program (VB or C++ or...) that will give you more control.



    Hey, that's a great idea! Oh, wait... ;)
  18. Replies
    5
    Views
    1,142

    Re: NOW keeps updating previous entries

    Nobody likes a smart-***. :rofl:

    Just kidding. :) Thanks, that's much more efficient.
  19. Replies
    5
    Views
    1,142

    Re: NOW keeps updating previous entries

    Now you have to copy and paste the value into the cell instead of the formula.

    I use this, it's attached to a button so I select the cell I want the date in and click the button. (Not formatted...
  20. Replies
    7
    Views
    485

    Re: Stop any other program while running VBA?

    As far as protecting the entire computer while in Excel, you're dreaming.

    Some of the things I've seen my 7 year old do while at stores that do this type of thing are:

    ALT-F4
    ATL-TAB...
  21. Replies
    7
    Views
    3,445

    Re: How to Control Output of .IQY File?

    The data is returned to MS Excel.

    I set it up by copying the URL for our Blue Data Minor database and put it into an IQY file. Double clicking the IQY file opens Excel and imports the data.
    ...
  22. Replies
    7
    Views
    3,445

    Re: How to Control Output of .IQY File?

    The database is on our intranet and I'm not getting much support from IT. (They're a bit touchy when cube dwellers like me mess with their chee.)

    I found IQYs by accident. I've been using a URL...
  23. Replies
    7
    Views
    3,445

    Re: How to Control Output of .IQY File?

    Anyone? Bueller? Bueller?

    Is nobody else using IQY files? Is there a better way that I don't see?
  24. Replies
    2
    Views
    506

    Re: Please Help Me Select Cells

    For i = 1 To rng.Rows.Count

    ^^^ This! :biggrin:

    Thank you. Works perfect.
  25. Replies
    2
    Views
    506

    Please Help Me Select Cells

    I've got a cheesy macro that goes row by row and sets conditional formatting to color the highest value in red and the lowest value in blue. It was made by recording and modifying. It works well but...
Results 1 to 25 of 143
Page 1 of 6 1 2 3 4