Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    6
    Views
    987

    Re: Associate Name to Number

    Replied before thinking it through and added an Edit. :/ #crazyface :)
  2. Replies
    6
    Views
    987

    Re: Associate Name to Number

    This could work better. The array count would also be the same if building them at the same time. Perfect. Thanks.

    Edit: Maybe not, because I'll need to sort the array alphabetically by name,...
  3. Replies
    6
    Views
    987

    Associate Name to Number

    Code isn't really need, I can figure that out, but looking for alternate ideas that might be better than what I'm thinking...

    I need to associate a number to name. I was thinking about just using...
  4. Re: Reading specific lines of a text file

    That works for the single word, I already though about that, but the User variables have 2 words and I only need the 2nd word in the var.

    Edit: Nevermind, I found a function for obtaining the last...
  5. Re: Reading specific lines of a text file

    One last thing on this. I'm so close, but always have difficulty manipulating strings.

    We'll just use the First User1 var as an example. this is what I have now.....



    User1 =...
  6. Re: Reading specific lines of a text file

    That's funny because I had "and" at first, but obviously I may have had something else off which made me second guess it. In rethinking it, which if I would have done this last night It could have...
  7. Re: Reading specific lines of a text file

    That's what I thought too, but then what should be row 21 is one of the rows that is just a {, same with row 23. What should be 26 is row 29; and what should be row 27 is actually row 31.

    Well,...
  8. Reading specific lines of a text file

    I'm trying to read 5 specific lines of a file and put them into a 5 different variables. The first one gets the correct line, but the other 4 are getting data that are not the lines I'm trying to...
  9. Replies
    9
    Views
    958

    Re: Anyone a member of VBForums too?

    Sorry you had to sign up for an account you didn't need though. The funny part is that today I got another email from the system, this time with a different canned registration message that said just...
  10. Re: VBScript: Loading to background issue.

    ....and I figured it out. Whew!!!! *wipes brow*

    The problem was not in the code at all, but was lack of code in previous attempts testing the script and in previous attempts the IE Object was...
  11. Re: VBScript: Loading to background issue.

    Made some progress on this. I found out why clicking Cancel went to the background.... Well, not the reason why, more what was causing it. I still don't understand the why. Although by...
  12. VBScript: Loading to background issue.

    I'll try to make a long story as short as possible. I have a script I'm working on that keeps loading windows to the background. Otherwise, it functions as it should with what is currently...
  13. Replies
    9
    Views
    958

    Re: Anyone a member of VBForums too?

    I can do that. A moderator said it was okay. :)

    StackOverflow confuses me. Reminds me of Yahoo Answers. It's not really a message board, but just questions and answers..... or it's not setup...
  14. Replies
    9
    Views
    958

    Re: Anyone a member of VBForums too?

    I saw that too. Like most message boards, including here at Mr. Excel, activation is done through the email confirmation that can't occur because they have it pointing to the wrong place. There's...
  15. Replies
    9
    Views
    958

    Re: Anyone a member of VBForums too?

    Many times. Sure I can login, but can't post, can't comment, can't reply and can't privately message anyone. Sorry, I did not intend for someone who wasn't a member to sign up. I was just hoping...
  16. Replies
    9
    Views
    958

    Anyone a member of VBForums too?

    Is there anyone here that is also a member of VBForums that might want to help me out with an issue? Not sure where else to put this request, so the general Lounge seems like the most appropriate...
  17. Re: Statement always true even when it's not

    Nevermind, I found it. Brain dead today....



    If Cells(i, "A").Characters.Font.Strikethrough = True Then
  18. Statement always true even when it's not

    Can someone help me out with this? I'm just trying to hide rows that the font is strikethrough, but the following code acting as if every row is strikethrough. Some are, some are not. *scratching...
  19. Re: XL2010 for loops not working / ignored

    Deleting rows of data that aren't applicable to the form the rest of the data will be auto-filling.



    Sub delnonGD()
    Dim i As Long

    For i = 16 To 2 Step -1
    If Cells(i, "T") <>...
  20. Re: XL2010 for loops not working / ignored

    BAH! It is with the loop.... That's me trying to be in a hurry to get things done. The faster I go the slower I am. Thanks.
  21. XL2010 for loops not working / ignored

    Somehow all my for loops are now broken and I don't know how it happened. It's like XL is just ignoring it. If anyone has any clue why this is happening, please let me know.

    Example: The...
  22. Re: Keyboard Shortcut: Copy value of selection not formula

    Thanks. I just realized I need update my tag line. Xl2010 now so I suppose Right Click can't be avoided. I found Right Click S E will paste special with values and keep formatting. I suppose ...
  23. Keyboard Shortcut: Copy value of selection not formula

    I'm looking at http://www.contextures.com/excel.htm which gives a lot of keyboard shortcuts, but not specifically what I'm looking for.

    It's a basic function, I'm surprised it's not listed. I...
  24. Replies
    4
    Views
    1,544

    Re: VBA: Autofilter Criteria

    Thanks for the info. This is the end result, unless you see a better way of doing it.

    I pulled out an old function from another project to build a unique array and modified it to allow for an...
  25. Replies
    4
    Views
    1,544

    Re: VBA: Autofilter Criteria

    Can I use the array method with the not operator? IE: <>array

    Currently there are 5. Bear and Frog were just used as examples. That could vary in the future and need the ability to add more.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4