area

  1. MCTampa

    Grouping Consecutive Values by Min and Max

    I have the following table for which I would like to create groups of consecutive weeks by min and max values. <caption>Automatics</caption><thead> AREA Code Week </thead><tbody> 330 1 330 2 330 3 330 4 330 33 330 34 330 35 330 36 330 37 330 38 330 39 330 40 330 41...
  2. S

    Formula to compare 2 cells with different text

    So I am trying to create a formula that compares to different cells to make sure the area assigned is correct. The problem is how the text is written ... Cell B1 the text reads "Group 55 Region E Area 558" in Cell B2 the text reads "55E8" I need a formula that compares B1 to B2 that shows 55E8...
  3. D

    resize for copy

    how do i adjust the following code to change the copy and paste from Range("A" & i) to ("E" & i ). i get a object doesnt support the property when i change A to E. I tried to do offset(0, 4) and get a "You cannot past this here because the Copy area and paste area are not the same size...
  4. Dan Wilson

    Controlling print-outs

    Good day. I am running Excel out of Office 365 on Windows 10 Home. I have a workbook that contains seven worksheets. Each of the worksheets has a group of Macros that allow the user to sort the data of each worksheet by different columns. The worksheets contain up to 200 rows with 125...
  5. K

    Programable Print Area?

    Is it possible to adjust the print area program-ably? I have a print area of say Cell A1 to Cell E50. This will do for 80% of my needs. Occasionally the table may extend another 15 rows or so. For this I would like to add a column F and use an "If" statement like If(E51 <>"", Set print area A1...
  6. T

    Grouping via VBA (dynamic record set)

    Hello, Hope someone can help. I have a refreshable sheet named "Report" with data running from A6 down to A150. Months from April 2019 to March 2020 run across the page. This data in column A is in the format AREA1 Worker 1 Worker 2 AREA2 Worker 1 Worker 2 Worker 3 etc and it all finishes...
  7. P

    VBA to check if circles are inside of freeform area or not

    Hi, Im newbie on this site and I need help with this : I have Freeform area and shapes in form of circles named from A to G. Some of this points are inside of Freeform area and some of them no. I need macro which will check each of this points if this point is inside/ outside of freeform area...
  8. K

    Print area using table/range of cells

    I have a sheet with about 20 tables of data (one table per tenant), and I would like it to print as many of these tables as can fit on one sheet, but I don't want it to split any of the tables across two sheets. For example, if page 1 could feasibly fit 2.5 tables of data, I would want page 1 to...
  9. R

    email area using Yahoo

    Hi guys, Hoping you can help me, I have a range of cells on a sheet A1:H32. I want to automate copying this area as a bitmap and sending to multiple recipients using my yahoo email. Does anyone have a bit of code for this please? Thanks Fletch
  10. willow1985

    VBA move print area down 1 row from active cell

    Hello, I was just wondering what would be the code to adjust a print area down 1 row without using specific ranges? I currently have a macro that finds the end of a table and adds a row for new data however I would like to expand the print area after I add the row by 1 row. the only code I...
  11. L

    I need creating vba code.

    red cells I want a vba code that only go that area Get File from Link before https://1drv.ms/x/s!AnJwxxiz0Ezpg8d44doit5nmxCco9A?e=b7ucl2 Ty Thomas
  12. B

    Force print area - does not change when hiding cells??? Help

    Hi All, I need some help with this one please. I have a spreadsheet that is a schedule, it lists week by week until the end of the year, this helps us plan out future works but we only send 2 weeks worth to a client. once the current week is over, we 'hide' the week, which in turn moves the new...
  13. S

    VBA - Print Area Change (from a set range)

    I have an Excel template (wb1) containing VBA to print the set range of a sheet in another workbook (wb2) via a command button. Depending on the options chosen in wb1 will depend on which sheet w/in wb2 prints. The code works, but wk2 contains many sheets (each having their own print area set...
  14. E

    Excel VBA replace duplicates for large formula

    Hi All, I have some percentages for 3 weeks for 3 different Areas in Area 1) B1:V100 Area 2) AB1:AV100 Area 3) BB1:BV100 now what i want to do is get the 5 largest values for each day 5 largest for each day ie B1:B100 C1:C100 D1:D100 etc Now i know i can rank them and use a countifs...
  15. M

    Center cash flow over the whole page print area

    Hi, Can someone explain to me how I can get my print area centered out over the whole page? Currently it leaves most of the page blank, but I want it to be spread out whilst keeping to fit the sheet on one page.
  16. C

    Post "Date" in one Cell when any changes occur in cells C11:F61

    I have tried to follow an answer that you gave a fellow lost excel user. :) Unfortunately I can not get it to work so I need more information. I have a worksheet that is broken down into projects (areas in the worksheet). In each section I have to have one cell that tells when anything in the...
  17. C

    Lookup based 2 criteria

    Dear Folks, I need to lookup of a quantity plan value based on a Date and Area. I have 5 columns from B to F B = Date (is duplicate) C = Area (is duplicate) D = Scope of Work E = Actual F = Plan H1 = Date - criteria 1 H2 = Area - criteria 2 H3 = Result In H3, should be a formula to lookup...
  18. K

    vba print area

    hello all, i have a worksheet with column A-I, row 1-250. however i'm not necessary to use every row every time. the question is how can i simply set the print area automatically to last row thus i can use less paper?:rofl: it seems my code below will goto row 250 every time and i will print...
  19. E

    Phone number with area code mask number format.

    I need to set a mask (cell number format) to do this: Phone number can be with area code (lenght): 10 (2+8), 11 (2+9) or, without area code: 8 or 9. (non-us format) Some aleatory (non real) numbers just for example: 12345678 result "1234-5678" 1212345678 result "(12) 1234-5678 123456789 result...
  20. X

    Area graphs ends on axis mid point

    Hello Excel Gurus, I want the gray area to go through December column rather than stopping on the mid point. Any ideas how to do this neatly? see screenshot: https://ibb.co/qxnwBVv Forever thankful to this amazing community, Xavier

Some videos you may like

This Week's Hot Topics

Top