Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Replies
    7
    Views
    162

    Re: Find and Extracting Specific Data

    https://drive.google.com/open?id=1JhfXox61d8XdU8L3kks98AzWXfvI_Qql

    Unfortunately, after looking at several of the cells, there are a lot of instances where it was transcribed without fitting into...
  2. Re: Excel form resizing according to screen resolution

    I just want to add that if for some reason CalcSux's subroutine isn't working, you may need to modify the Declare function based on the version of Excel you are using.


    Declare PtrSafe Function...
  3. Thread: VBA question

    by gravanoc
    Replies
    8
    Views
    167

    Re: VBA question

    Hi Russ, an additional possibility is to name your ranges. I think that would cut down on the long parameters.
  4. Replies
    7
    Views
    162

    Re: Find and Extracting Specific Data

    I'm still working on it. The problem is that some of the cells do not follow the same format, making it difficult to use one or two search strings to match by. I have 90% success with it, but will...
  5. Replies
    7
    Views
    162

    Re: Find and Extracting Specific Data

    Hello red, I have a question. Do all of your cells follow the same format where the time is listed twice in each? Or does it vary? As is, I am working on a solution that identifies the time twice...
  6. Re: Help with understanding Declare Function & Windows Messages/Controls

    Thanks again! Btw, you should try it out, it's super useful if you're trying to learn the way Windows Messages works. I've been messing around with it for about an hour now.
  7. Replies
    6
    Views
    3,472

    Re: Chip Pearson - RIP

    Wow, I can't believe how tragic this is. Reminds me of my favorite college professor who also died in a wreck. I've used that site for years.. I wonder if there's a GoFundMe or something setup for...
  8. Re: Help with understanding Declare Function & Windows Messages/Controls

    Thanks for answering BlueAure! I've spent the last couple of days reading through the documentation & also the links you provided. I don't know if I go about learning the right way, but I usually...
  9. Help with understanding Declare Function & Windows Messages/Controls

    I have been studying some of the code snippets posted to the forums. I have a very broad question to ask, so forgive me if I ramble.

    I am trying to understand how VBA works with Windows Controls,...
  10. Re: Setting a cell's value and background colour through VBA

    Hi Philip,

    Glad to hear you got it working. As for how to get subroutines to work, it depends on how often it is going to be used. To me it seemed like a one use type thing, or a rarely used...
  11. Re: Trying to drag down vba formula - getting global error

    Src, did you place your code inside a Sub?

    Public Sub DoThis()

    'Code

    End Sub
  12. Re: Setting a cell's value and background colour through VBA

    If you are ok with a subroutine, this will do what you want (I think).


    Sub CreateList()
    Dim wb As Workbook
    Dim ws() As Worksheet
    Dim rng As Range
    Dim rngNow As Range
    ...
  13. Re: Setting a cell's value and background colour through VBA

    Hi, generally I've found that functions are not supposed to do formatting as per spec, but I think there might be a workaround. I'll see if I can figure it out.
  14. Replies
    1
    Views
    110

    Is Selenium worth using?

    I spent a while trying to find out if there is an up-to-date version of the Selenium add-in, but haven't had much luck.
    It's an add-in that allows VBA to manipulate Chrome and Firefox as object...
  15. Replies
    15
    Views
    370

    Re: Mixed messages

    I think what you are looking for is something like this:
    Public Function DateNow() As Date

    ActiveCell.NumberFormat = "[$-en-US]m/d/yy h:mm AM/PM;@"
    DateNow = Now


    End Function
    ...
  16. Re: When I tried to save it it said I cannot save it in a Macro Free zone.Re: Convert an Excel file into a PowerPoint file with one click of a button

    No problem. I'll be around if needed.
  17. Re: When I tried to save it it said I cannot save it in a Macro Free zone.Re: Convert an Excel file into a PowerPoint file with one click of a button

    Sorry, I forgot to mention there are some other steps you can take to try and get around that. You might be right though, if your company has a security policy it can be a headache.

    The file has...
  18. Re: Convert an Excel file into a PowerPoint file with one click of a button

    This is what I have so far.


    Sub ExcelChartsIntoPPT()

    Dim wkSht(0 To 30) As Worksheet
    Dim cRng(0 To 30)
    Dim pptApp As Object
    Dim newPPTX As Object
    Dim cSlide(0 To 30) As Object
  19. Re: Convert an Excel file into a PowerPoint file with one click of a button

    Ok, I got something working, but I need a bit more info on what you want to be transferred to the Powerpoint pptx. Is it just table data, or does it involve charts, etc.?

    Can you tell me what...
  20. Re: Convert an Excel file into a PowerPoint file with one click of a button

    I'm definitely not a guru, but I'm familiar with the syntax needed. This page describes the basic mechanism, so I can probably get something for you that works later tonight. ...
  21. Re: Convert an Excel file into a PowerPoint file with one click of a button

    Did you find a solution yet? I think I know how, but got to try it out in a bit when home.
  22. Re: Application.ConvertFormula behaves differently

    If you are still having problems, you could upload your workbook and I will see if the issue occurs on my cpu.
  23. Re: Application.ConvertFormula behaves differently

    Oh, one other possibility is that one of you is running an Insider edition. Maybe you could share some screenshots so I can see the layouts?
  24. Re: Application.ConvertFormula behaves differently

    Hi Skovgaard,

    Is it just 1 workbook open?
    If yes, and it is a setting of some sort, one quick way to check is to create a bunch of Debug.Print Application.XXSetting to see what turns up True ur...
  25. Replies
    76
    Views
    3,375

    Re: Code To List Numbers Missing From Sequence

    See if this works.


    Sub SequenceFill()

    Dim sh As Worksheet


    Dim rngFirst As Range
    Dim rngLast As Range
Results 1 to 25 of 69
Page 1 of 3 1 2 3