1. M

    Area Chart Help - Negative & Positive Values

    Hello, I'm trying to create an area graph to shade each range percentage listed in the far left column (pictured) a different color. Rage A - shade anything above 15% one color Range B - shade 5 - 15% a different color Range C - shade -10 - 5% a different color Range D - shade anything...
  2. B

    Dynamic Dates on Chart

    Hey everyone, I have a fixed table with dates (x-axis on desired chart) that go for several years into the future, but data (y-axis) that only goes a few months. This will be a working file where new data is added each month. I'd like an area chart to show the data across the dates that have...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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
  12. 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...
  13. L

    I need creating vba code.

    red cells I want a vba code that only go that area Get File from Link before!AnJwxxiz0Ezpg8d44doit5nmxCco9A?e=b7ucl2 Ty Thomas
  14. 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...
  15. 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...
  16. 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...
  17. 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.
  18. 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...
  19. 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...
  20. 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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back