Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.00 seconds.

  1. Replies
    12
    Views
    84

    Re: Print selection code doesn't work properly

    no tbh I see no other special info about this case. Hopefully it has something to do with the printer settings.
  2. Replies
    12
    Views
    84

    Re: Print selection code doesn't work properly

    or gives the outcome of what will happen if you execute this code
  3. Replies
    12
    Views
    84

    Re: Print selection code doesn't work properly

    not really, but it wouldn't change the meaning. So yes that's what happened
  4. Replies
    12
    Views
    84

    Re: Print selection code doesn't work properly

    It would just print some blank pages (probably because I have invisible formuals there) And funniest thing... still will print only 1 page of real data ( which I have on more than 1 page of print)
  5. Replies
    12
    Views
    84

    Re: Print selection code doesn't work properly

    Yes, I stopped the code before print and I see that it selects it.
  6. Replies
    12
    Views
    84

    Re: Print selection code doesn't work properly

    Well I didn't finish the post, but stupid Tab triggered with no cursor and selected the post thread while I was pressing Enter. In general question in body is the same I just didn't finish the title...
  7. Replies
    12
    Views
    84

    Print selection code doesn

    Hello, I am trying to create a code to automatically select the range (that can vary horizontally) and print it.
    I tried to use this code, but it prints only 1 page regardless the amount of pages...
  8. Re: Printing code ignores some data/pages

    Thank you , but looks like it still ignores it.
  9. Printing code ignores some data/pages

    Hello,
    I have this simple code


    Sub Printout()
    Sheets("Breakdowns").Select
    Range("A1", Range("A1").End(xlDown).End(xlToRight)).Select
    Selection.Printout
  10. UX design for times in Excel. How to "scroll" the times ?

    So I am working on user interface on one worksheet and not sure how to make time fields more user friendly.
    Right now it is just validation list in increment of 5 for minutes and separate field for...
  11. Is there a way to copy formulas from one excel file to all other excel files ?

    So I have certain formulas (in range) in one excel file, and I need to copy-paste them into other excel files grouped in folders.
    I wonder if it is possible to do it with VB coding or any other...
  12. What is the Substitute for COUNTIFS date based formula ?

    So I have this formula in excel in my raw data

    =COUNTIFS([Date range],">="&(EOMONTH(Date,-1)+1),[Date range],"<="&EOMONTH(Date,0))

    Power BI however doesn't have this function. I tried to use...
  13. Is it possible to avoid refreshing of present data in Excel Query ?

    I am trying to figure out how to continuously pull data from multiple excel files, but not allow excel/query to change manually edited values back to source values
    Example:
    I have June, July,...
  14. Re: Is it possible to teach Power BI a Text mining/analysis without using any platforms.

    Thanks for reply
    I know I can, but I am wondering if I can do that specifically for this task ? So far I didn't find any good material on how to do it.
  15. Is it possible to teach Power BI a Text mining/analysis without using any platforms.

    So far throughout my searches I always end up being offered MS Cognitive or Azure.
    Is it possible to somehow teach Power BI to recognize phrases with Python/R (or any other accessible tool) or build...
  16. Re: Is it possible to create a VBA code that would recognize phrases out of context ?

    Yeah, I was suspecting something like that, but still decided to try my luck
    Thank you for letting me know though.
  17. Is it possible to create a VBA code that would recognize phrases out of context ?

    So far I know how to extract certain words and potentially even match it into phrases without using VBA, but it is very crippled.
    But is it possible to teach/have VBA recognize the phrases out of...
  18. Re: Lookup value from reversed columns and rows

    Is it possible to create formula that would sum values by several dates for each location and assigned in the same case ?
  19. Re: Lookup value from reversed columns and rows

    Thank you a lot.
    That's what I have been looking for.
  20. Lookup value from reversed columns and rows

    Source table

    <colgroup><col><col span="5"><col></colgroup><tbody>

    tine 2
    tine 2
    tine 2
    Hitte 3
    Hitte 3
    Hitte 3
  21. Re: Do until loop doesn't work with complex reference formula ?

    Yep, I tried it exactly the way it is. While it did change one experiment formula, it didn't work with mine.
    However, I indeed had Fixed chosen. Once I got rid of it, it did work.
    Thank you a lot....
  22. Re: Do until loop doesn't work with complex reference formula ?

    Thank you response. It doesn't seem to work. I tried both code and text to columns button.
    Tbh, I am not well aware of text to columns, so maybe I am doing something wrong, but all it does is...
  23. Do until loop doesn't work with complex reference formula ?

    So generally I am trying to make my text formula work, but as many other methods, this one doesn't work for some reason.

    =IFERROR('K:\PLANING\Apr\[Thu, Apr 11.xlsb]Millright...
  24. Re: How to cell reference from certain files based on dates

    For some reason I cannot see uploaded picture. So just in case describing it here: It is Update Values popup window. It wants me to select the file (I press cancel obviously)
  25. How to cell reference from certain files based on dates

    I have daily files that "feed" information to summary file. Right now it is a manual process. (copy-paste)
    There are certain cell ranges in daily file that feed information to specific sheet and...
Results 1 to 25 of 53
Page 1 of 3 1 2 3