I was make Print to PDF With Duplex page , its Work , But How to set (Top, bottom, Left, Right Margin) in this VBA code....
i was Create MODULE and put this VBA code , So Amazing Trick to ,make Print TO PDF with Duplex (Both-side),,,,,
Kindly Provide set VBA code For both page Margin...
@ HOW TO LOCK COLUMNS ???
I try Column " A" & "B" FIX & Lock .......
This "HSN CODE " IS EVERY TIME FIX & SAME IN BILL .........
Problem : 5 and more people use this File, So my was Change every time , i tried ...
We Need lock Columns lock trick ..
pleased solve my Query.
<tbody>
Range
of
Values
New
Existing
1
to
10
10%
8%
10
to
50
3%
2.5%
50
to
100
.8%
.4%
</tbody>
<tbody>
Type
Value
Percentage to Return (from the New/Existing columns above)
New
40
??? -What formula to use???
Existing
40
??? -What formula to use???
New
60
??? -What...
Hello,
I need to combine if and sumifs function for this case that i have. (according to my lecture)
The case is : to fill product cost column (Sheet 1) , they asked me to put the sum of unit price ( in Sheet 2) if the product type (Sheet 1) is Manufactured. If the product type is Bought-in...
Hi,
Is it possible to create a form on excel to have it mail merge with outlook and be sent out to clients ?
I.E. I want to create a document in excel where you can answer questions and those questions get answered for us and put nicely back into excel. If anyone know how this would be setup...
Good afternoon,
I need to write a formula that does the following:
If cell is (#### or #### or any letter combination) then put "MA"
if cell is (#### or ####) then put "SC"
#### stand for a combination of a few numbers.
Haven't been able to figure it out. Thank you!
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 MrExcel.com.
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 "mrexcel.com".
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.