Search:

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

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: Excel-Word Interop, Add Watermark Issue

    Bump.
  2. Excel-Word Interop, Add Watermark Issue

    I have a workbook that will convert multiple word documents at once into PDF format. I am combining two macros I found on the web to try and get them to open a word doc, place a watermark on the...
  3. Re: How can I set a range variable that only includes cells in that range with data?

    Thanks Dante, huge improvement!
  4. Re: How can I set a range variable that only includes cells in that range with data?

    I should add that I'm using the Camera command. It slows things down, but it has to stay. Here's my workbook: https://drive.google.com/open?id=1KGzr30xATU2KI9EopS8Gvfc-jPb07nZN
  5. Re: How can I set a range variable that only includes cells in that range with data?

    Public Sub FormatCells()

    Dim rowCount As Long
    Dim i As Integer
    Dim c As Variant
    Dim fCell As Variant
    Dim jpSheet As Worksheet
    Dim str As String
    Dim borderRange As...
  6. How can I set a range variable that only includes cells in that range with data?

    I have a very slow subroutine that uses a For Each statement to iterate through about 30 cells in a pre-defined range, checking if they have text in them, and then performing a bunch of formatting...
  7. How to save meeting dates permanently with Excel?

    Someone wants the meeting dates they have held to be recorded and to be retrievable. This kind of makes me think a proper database is required, but maybe someone has a reasonable format where this...
  8. Re: SUMIF Current Month equals Dates in Range

    Thanks, that works!
  9. SUMIF Current Month equals Dates in Range

    My SUMIF isn't working, and I'm wondering what I need to do, or if an alternative is needed. Basically, I need to total up some profits if they were earned during the current month, whatever that...
  10. Re: How to combine totals for a sheet with multiple entries for the same thing

    That is fine, thanks Sandy
  11. Re: How to combine totals for a sheet with multiple entries for the same thing

    Thanks that seems to help, but one other problem is that I have a lot of data where the player didn't score any goals for a particular season. Is it possible to remove or filter these results in...
  12. Re: How to combine totals for a sheet with multiple entries for the same thing

    It is only 22 columns. 21 seasons + 1 player column.
  13. How to combine totals for a sheet with multiple entries for the same thing

    I have a large sheet with soccer players & the number of goals they have scored each season (each column is 1999-2000, 2001-2002, etc. up to 2019-2020). The players names are often duplicated down...
  14. How is it possible for the same exact value in one cell to fail my conditional formatting while elsewhere it doesn't?

    Here is what I'm trying to do.

    A meeting or documentation turn-in needs to be scheduled for a certain date & be held, otherwise the cell where the date goes turns red and bold yellow font. I use...
  15. Re: Conditional Formatting contradicting formula

    Update: It's working now. The way I fixed the earlier problem was by re-arranging the cells in the reference sheet to all be in the 1st row.
  16. Conditional Formatting contradicting formula

    Gee, my favorite topic! Conditional formatting is kicking my *** again.

    Problem Statement: My conditional formatting formula is applying formatting to the correct & incorrect cells, all except...
  17. Re: UserForm TextBox.Value type mismatch with variable

    One more thing that I should mention. When I hit the Stop button in the VBE, it is causing Excel to crash. Any ideas why?
  18. UserForm TextBox.Value type mismatch with variable

    I've got a simple script that is giving me lots of pain. I am simply trying to validate the number entered into my first TextBox to ensure that there is not a duplicate of a job number for a...
  19. Re: Need a combinations formula for possible outfits

    I have tried modifying another formula:...
  20. Re: Need a combinations formula for possible outfits

    Also, I'm trying to make the full list of all the combinations using a formula. I have found a good formula that works with two columns, and am trying to update it to work with five columns....
  21. Need a combinations formula for possible outfits

    I need an excel spreadsheet that shows all the available combinations for a wardrobe. I think I have the logic right, but need a confirmation if this is right.

    List of wardrobe items: ...
  22. Can this scenario be modelled within Excel?

    The purpose is to ensure that an expected number of new clients will be served by a sales representative on schedule. Normally, you hire sales reps and then get clients, but for the purposes of...
  23. Replies
    3
    Views
    132

    Re: Return Positive Value of SUMIF

    Another neat trick is to put a - in front of your Sumif. So =-SUMIF(U5:U91, "2", N5:N91)
  24. Re: Count number of Employee base on schedule

    Do you need me to upload the workbook? Alternatively, if you just type 12:00 AM in F2, then 12:30 AM in G2, you can drag the 2 cells across to 11:30 AM, then repeat that process starting with 12:00...
  25. Replies
    30
    Views
    698

    Re: keyboard Shortcut for the character

    As an aside, there is a non-Excel solution to this. You would need to understand how to use AutoHotkey or own, say, a programmable mouse. Then you could run a macro when you please.
Results 1 to 25 of 114
Page 1 of 5 1 2 3 4