Search:

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

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Replies
    4
    Views
    167

    Re: Can't handle named ranges in SUMIFS

    Had to expand and populate the table with data once more and that fixed it. Still not sure why SUMIF worked, but SUMIFS didn't but at least it is functional now. Thanks for all the contributions!
  2. Replies
    4
    Views
    167

    Can't handle named ranges in SUMIFS

    Hi!

    I'd need some ideas in troubleshooting SUMIFS formula that returns #VALUE ! error
    I have a named ranges (within a table) to check particular "Department" + named range to check particular...
  3. Replies
    6
    Views
    187

    Re: Copy-paste from partly unknown range VBA

    Thank you, looks great!
  4. Re: Excel parameterized SQL query with IN clause

    In addition to any possible simplifying of the VBA code, it looks like I have to use it for more than 1 query. They are all on the same worksheet though. Could this be possible too? I'm assuming this...
  5. Re: Excel parameterized SQL query with IN clause

    Hello again John! This is starting to look fantastic! I'm not the fastest thinker you'll ever meet, however I now see this Worksheet-level VBA adjusts the SQL string itself from ? to whatever the...
  6. Re: Excel parameterized SQL query with IN clause

    First of all - thanks for taking the time!
    But phew, that's some next level stuff. Unfortunately when adding this VBA to Worksheet level and changing data in M1:M4 range, I get an error message: ...
  7. Excel parameterized SQL query with IN clause

    Hi!

    I'm running Office365 package Excel 2016 with MS Query to DB2 SQL database with the query being parameterized towards a specific Excel cell value (although I need to populate this cell from a...
  8. Replies
    6
    Views
    187

    Re: Copy-paste from partly unknown range VBA

    Thanks, that does the basic job quite well! Didn't know the .UsedRange and .CurrentRegion methods, but we are here to learn! I don't really need (nor want) to first clean the entire Sheet1 as there...
  9. Replies
    6
    Views
    187

    Re: Copy-paste from partly unknown range VBA

    Phew, here's perhaps a partial answer. I guess I have to identify the final row and somehow integrate that value in the Range selection? So this should give me the final row number to be copied:

    ...
  10. Replies
    6
    Views
    187

    Copy-paste from partly unknown range VBA

    Hi!

    Sorry for the vague subject. I have a seemingly simple task at hand, however lacking ideas towards solution. Can't even figure out great keywords for search.

    I need to copy some data from...
  11. Re: Understanding Conditional fomatting in RangetoHTML

    DanteAmor, thanks a lot! Great input, well appreciated.

    I think I ended up with "not hide" the column option, however made VBA change the column so that it's virtually invisible (though not...
  12. Understanding Conditional fomatting in RangetoHTML

    Hi!

    Utilizing Ron de Bruin's code to email Excel range over Outlook in HTML, however could you guys help me understand the conditional formatting part. I want to focus on 3 columns in my range: E;...
  13. Replies
    8
    Views
    220

    Re: Excel VBA filtering loop issue

    Sure - this appears to be working for me:


    Sub Filter_mail()


    Dim ws As Worksheet: Set ws = ThisWorkbook.Sheets(1)
    Dim i As Long, Arr
  14. Replies
    8
    Views
    220

    Re: Excel VBA filtering loop issue

    I have to correct myself as it was indeed necessary to use Arr(i) for filtering through the array. I was also able to fix the IF clause and link it to SUBTOTAL formula which counts visible rows in a...
  15. Replies
    8
    Views
    220

    Re: Excel VBA filtering loop issue

    Didn't know the F8 trick before! But went though it step by step and it is indeed launching the filtering in 3 different cycles and with details as I expected. However with one value, filtering...
  16. Replies
    8
    Views
    220

    Re: Excel VBA filtering loop issue

    Interesting, I thought the filtering loop to be OK as the VBA looked to quickly push through different filtering options and always ended with the final value within the array being used as a filter....
  17. Replies
    8
    Views
    220

    Excel VBA filtering loop issue

    Hi guys! Trying to implement a VBA loop the first time and struggling with it. I have table Table1; separately defined range Filtered (same area as Table1, however no headers) and hardcoded array of...
  18. Data refresh on a protected sheet (w/o VBA)

    Hi!

    Plenty of threads on this one, but I'm still confused. Whenever I protect the worksheet, possibility to refresh a table is disabled (external data connection to IBM DB2). Shouldn't be a...
  19. Replies
    3
    Views
    163

    Re: Date format together with a string

    Murphy's Law at work. Thought I had gone through all the options I found in the web, but stumbled on pretty much the same solution minutes after posting the thread. Thanks a lot and it really did do...
  20. Replies
    3
    Views
    163

    Date format together with a string

    Hi!

    Struggling to find a formula (or cell formatting?) to present proper date next to a string. This works fine to present a correct date 5 days from now: =TODAY()+5 however I would need to run...
  21. Replies
    0
    Views
    100

    Excel page break between Table & Range

    Hi!

    I got a page break challange in Excel (2016) worksheet. I have a defined table containing statement of account ("Table1") - the table is autoexpanding and populated with a copy-paste function...
  22. Replies
    6
    Views
    412

    Re: Coverting YYYYMMDD into proper Date

    Thanks guys! I used the =--TEXT(A1,"0000-00-00") option and it worked nicely! Option by Fluff worked too, however I found TEXT function to be simpler. I had to remove the "--" from ahead of TEXT...
  23. Replies
    6
    Views
    412

    Converting YYYYMMDD into proper Date

    Hi!

    I have an Excel 2016 worksheet with a data connection to db where I query contents to Excel. It is a simple table with invoice numbers and due dates. Those are exclusively unpaid overdue...
  24. Replies
    8
    Views
    436

    Re: Reverse table resize + clean contents

    Sorry for the multitude of messages, however there seems to be some sort of a issue with protected worksheet which is causing this. Looks like
    ListRows.Add populates the 1st row with the formula...
  25. Replies
    8
    Views
    436

    Re: Reverse table resize + clean contents

    Hi again!


    After some testing and having a look at my hidden columns, running the code provided by Yongle turned out not to be a great option (for the same reason Yongle already suggested) - I do...
Results 1 to 25 of 42
Page 1 of 2 1 2