margins

Error rows going onto next page when space left on page, only seems to happen for this workbook, all others seem to fill ok. But there is a fair amount of invested time in layouts formula, and macros that would be a pain to switch to a new workbook (so i'm leaving that as last resort) Workbook...

0 <button class="js-vote-down-btn grid--cell s-btn s-btn__unset c-pointer" title="This question does not show any research effort; it is unclear or not useful" aria-pressed="false" aria-label="down vote" data-selected-classes="fc-theme-primary" style="margin: 2px; box-sizing: inherit; font-size...

Hi All, Is it possible, to have printout in Excel with NO margins (maybe with macro) ? Thank you in advance.

I have this dataset: <tbody> User Date Time A 9/1/2019 8:00 AM A 9/1/2019 10:00 AM A 9/1/2019 4:00 PM A 9/1/2019 5:00 PM A 9/2/2019 8:00 AM A 9/2/2019 5:00 PM B 9/1/2019 9:00 AM B 9/1/2019 3:00 PM B 9/1/2019 5:00 PM </tbody> The first thing I want to do is add a subindex on...

Hello I am trying to print and have the vba code adjust margins so i don't have to every time. The issue im running into is that it wont print it to a 11x17 pdf size and it wont fix the margins for me. It wont print to scale. Anyways it keeps saying "Document not saved" AND when i debug it...

Hi, I'm looking to increase the size of the margins in my cell, particularly the vertical. i.e. - I want there to be more white space between the rows. When I select Format cells, sometimes the text tab is there to be able to change those margins, but many, many times, it's not. Is there...

I want to print below a logo letterhead but cannot get the margins set as I need them?

I am trying to determine a margin based on my total cost of products For example I have multiple line items with a cost I want to add a margin to each line item depending on it range <1000 add 45% margin <5000 but greater than 1001 add 43% margin <10000 but greater tan 5001 add 35% margin etc

Can someone please help me with possibly an advanced macro. I process a bunch of different reports with different sizes, sometimes single tabs, sometimes multiple tabs, different rows or columns of data and different formatting etc. But every report I send has a few formatting requirements and I...

Hi everyone, I had an issue with a macro in my workbook, which is now resolved. However, I can not get the margins, headers and overall formatting of my document back to the way it was. I've re-created it, tried it from another version of excel, even a different pc but the margins are just not...

Good day all I was hoping that someone could be of assistance. I created a complex workbook with all kinds of Userforms, Modules and VBA coding. The resultant workbook is a separate workbook created by my Excel utility that consists of a Sheet copied from my utility. Upon initial setup of...

I have removed all the Margins , Header & Footer... Thanx Brian

I need help writing code to set margins within the cell comments themselves in VBA. I have found posts to set every other kind of margins, but not in cell comments. let me know if you know of any. For Each MyComments In ActiveSheet.Comments With MyComments .Shape.AutoShapeType =...

Hello, I have code to set the print margins on an excel sheet with 9 sheets printed. The code is the following: <code> ActiveSheet.PageSetup.PrintArea = "$A$14:$P$87,$A$88:$P$155,$A$162:$P$221,$Q$14:$AE$87,$Q$88:$AE$155,$Q$162:$AE$221,$AG$14:$AV$87,$AG$88:$AV$155,$AG$162:$AV$221" </code>...

Hi guys! i made a macros that sorts people's names. it has 2 columns, the names, and the desk number. however, when i go to print it, the print space doesnt include the first column, only shows the desk space column. and the first page that prints is blank. to fix it, i have to go to page layout...

NOG stands for Nett On Gross and is calculated by dividing cash margin ex VAT by retail sales including VAT. Whereas the standard method of working out retail margin is cash margin divided by retail sales excluding VAT. NOG example Retail Sales Price of Product X = £2.00 Less 20% VAT = £1.67...

I am attempting to find the usable page size so that I can set Page Breaks in VBA. I have it working with the following code. But it is only guess work. I would like to be able to know when I am going to overflow the bottom of the usable space rather that guessing at how big it is. There is...

Hi, I'm looking for a way to change the margins while changing the orientation of the page in Excel. When in portrait mode the margins need to be: Left/Right: 2,3; Top/Bottom: 3,6 and Header/Footer: 3,3 (cm). In Landscape it should be: Left/Right: 3,3; Top/Bottom: 2,3 and Header/Footer: 2 (cm)...

There are often times when reports or data sets are larger then what can normally fit on one page. When ever this happen I usually go into page break view or set rows/columns to fit to one page. This works great for getting what you need down to one page. However whenever I print that one...

I am using Excel 2016, Windows 10. How do I display/show the margin settings of the current worksheet, using VBA. Thanks, Judy