Resizing Diagrams Without Getting A "compressed" Or "stretched" Result

Jun 9, 2008

I have several charts which I want to make the same size, without some getting "compressed" and others "stretched"?

My goal is in other words to get uniform diagrams.

View 10 Replies


ADVERTISEMENT

Extract Compressed WinZip File Attachment

Dec 30, 2004

extract compressed excel file attachement...

i am emailing an excel file as an attachement in outlook 2003 on a windows xp professional...

i would like to compress the file and then send it...

but i don't know how to extract it in vba code on the receiving end...?

View 9 Replies View Related

Suppress: Cannot Copy A Compressed (Zipped) Folder Onto Itself Message

Dec 23, 2007

i get the error messagebox:
title bar " compressed (zipped) folders error"
"cannot copy a compressed (zipped) folder onto itself"
with only the OK button

when i run

oapp.namespace(filenamezip).copyhere oapp.namespace(foldername).items

View 6 Replies View Related

Zip Workbook File By Using "Send To Compressed Zipped Folder"

May 8, 2009

Is it possible to save/send a workbook to compressed zipped folder by vba.
Using standard windows zip method (refer right click file option). As all users will have this feature, as i dont want to use a thrid party zip app.

So i and other users can automate zip of workbook into an email via macro.

View 2 Replies View Related

Resizing Name Box

Jan 19, 2007

I can't find a way to re-size the name box (the one in the top left hand corner of a spreadsheet, to the left of the formula bar), or change the type size that this box uses.

I've looked through Excel help, but I can only find help on re-sizing toolbars and not the name box.

View 9 Replies View Related

Resizing Textbox On The Fly

Oct 13, 2011

I now have 5 textboxes "on top" of one other (i.e. vertically arranged). I would like to - depending on which checkbox is checked - extend the top one all the way down and make the bottom four invisible. I'm pretty sure I can handle the second part:

Code:
Textbox2.visible=False

For example. How to resize a textbox?

View 7 Replies View Related

Resizing Range With VBA

Sep 30, 2012

I have table1 that has its original range as A1:B3. Depending on the amount of n in another column, I want table1 to be resized to A1:Bn.

I have tried with

ActiveSheet.ListObjects("Table1").Resize range("A1", "witdh")

with "width" being a variant.

View 9 Replies View Related

Resizing Range In VBA

Oct 26, 2013

I am trying to copy down a range of formulae using the resize function. Here's the code I have :-

Code:
Dim no_of_transactions As Long
no_of_transactions = Last_Row_of_data(main_workbook.Sheets("working").Range("g2"))
main_workbook.Sheets("working").Range("w2:ak2").resize(no_of_transactions,1)

However I am told by the vba editor that I need an = sign ? The function Last_Row_of_data tells me the number of rows that I have.

View 4 Replies View Related

Resizing Range VBA

Apr 18, 2006

I have a worksheet named Advisers with a range also named Advisers, the range is a list of names which is added or deleted from by use of a UserForm.

I have the following lines of -
The first populates the worksheet
and
The second is supposed to resize the range Advisers accordingly but it gives a Run-time error I've tried the 2 examples below


c.Offset(0, 0).Value = Me.Adviser_txt.Value

Worksheets("Advisers").Resize(Range("Advisers").Rows.Count, 1).Name = "Advisers"

c.Offset(0, 0).Value = Me.Adviser_txt.Value

Worksheets(Sheet2).Resize(Range("Advisers").Rows.Count, 1).Name = "Advisers"

View 9 Replies View Related

Range Name Resizing

Aug 2, 2007

= SUMIFS(E9:E1494,C9:C1494,1) This formula works ok. If I rename range E9:E1494 as "Col_1" and change the formula to =SUMIFS(Col_1,C9:C1494,1). I get #VALUE error.
The range is formatted as number.

Also ...

If I delete some cells in a range, referring formulae are modified accordingly, but if I add cells in the range the formulae do not recognize the change

View 4 Replies View Related

Resizing Non-contiguous Range

Apr 8, 2008

Is it possible to re-size a non-contiguous range? I'm guessing "no", and a Google trawl hasn't provided me with anything.

Here's what I'm trying to do:

dim mult_rng as range
dim rng2 as range

set mult_rng = range("A1:B1,D1:E1")
set rng2 = mult_rng.resize(rowsize:=10)
That is, my original range is comprised of non-contiguous cells in the same row. When re-sizing, I'm trying to increase the number of rows, but leave the columns the same.

Like I said, my gut instinct says that this isn't possible using the 'resize' property. Can anyone think of another method to use? My constraints are that the original mult_rng isn't always the same (and isn't always non-contiguous).

View 9 Replies View Related

Centralise Userform After Resizing

Jun 3, 2006

i have a command button on a userform that resizes/inlarges a userform.

i need some code to place the new sized form in the centre of the screen once the resizing code is executed.

View 3 Replies View Related

VBA Code For Resizing Arrows To Specified Length?

Jun 7, 2013

I have created this Excel schedule that is attached. The point of the schedule is to organize Jobs and Crew members. I have VBA code in, so when I calculate how long the job should take, the arrows next to the job will automatically extend. (This should all make sense if you take a look at the attachment.) The only problem is that my arrows do not extend the correct distance. In the attached file I have scheduled "James Lorenz" to do a job starting on tuesday, towards the bottom of the page I did my calculation that figures he should be on that job for 9.5 days. I would like the Arrow next to James' job to extend 9.5 days on the calender instead of 9.5 centimeters or whatever it is doing now.

View 9 Replies View Related

Auto Column Width Resizing

Feb 13, 2014

Lets say i type for now...
A1 = USA
B1 = Philippines

and then later
A1 = dog
B1 = cat

Is there a way that the width would automatically adjust even as I change the values of the given cells; meaning, if a word is long, the width will automatically adjust "longer", if a word is short, then it will automatically adjust "shorter".

I know how the "AutoFit Column Width" works but I don't want to press that every time my values change (words becoming shorter or longer).

View 4 Replies View Related

Merged Cells Lock After Resizing

May 17, 2014

I finally have the merged cells resizing the way I need, however it seems to lock the cell after the process not allowing it to be edited again until I unlock the sheet. below is the current code I am using

[Code] .....

View 5 Replies View Related

Chart Sheets - Resizing And Exporting

Jun 3, 2006

I have a two-parter...

1) Is it possible to write a macro that will resize fonts in a chart (axes, text boxes) to specific sizes?

2) I usually copy chart sheets and paste them into Publisher but I have to resize them because they are huge when pasted. I would like to create a toolbar command that will take the selected chart sheet (not just a chart in a worksheet) and resize it and its components (part 1) to specific dimensions, then copy it as a picture so that I can simply go to Publisher and paste the chart after pressing said button in Excel.

View 9 Replies View Related

Resizing Charts And Positioning Legend

May 4, 2007

I have made charts in VBA charts that needs to be placed on specific position and have specific sizes on a chartsheet. I use plotarea (top, left, width, height) for that. Unfortunately when I set these values they keep chaning, there is some scaling going on in Excel and they won't get the specified size. I have been looking on the internet and finally I found a piece of code which works, but still not good enough, because the legend is also not good positioned

De data for resizing the new charts (ChtNew), the legends and the charttitle I get from other charts (ChtOrig). The legend.legendposition of ChtOrig does not have a value but it still have a top,left,height en width which I use.

I show you my code, the part with the for-next is taken from the internet.
I am trying to find a solution now for 3 days and now I only dream of huge charts (which is not good). So please can someone help me with this? This is the last forum, that I can try, I didn't get reactions from others.

with ChtNew.legend
.Top = ChtOrig.Legend.Top
.Height = ChtOrig.Legend.Height
.Left = ChtOrig.Legend.Left
.Width = ChtOrig.Legend.Width '* 1.1
.Top = ChtOrig.Legend.Top + ChtOrig.ChartTitle.Top
end with

With ChtNew.Plotarea
.Top = ChtOrig.PlotArea.Top
.Height = ChtOrig.PlotArea.Height
.Width = ChtOrig.PlotArea.Width
.Left = ChtOrig.PlotArea.Left

For i = 1 To ChtOrig.PlotArea.Top........

View 9 Replies View Related

Resizing A Form To Fit A Variable Number Of Checkboxes

Jun 7, 2006

create a form that will look at the spreadsheet and figure out which of the 32 possible checkboxes will be used and resize accordingly. I can make it so that only the checkboxes I want are visible using the .visible property, but for the sake of aesthetics I'm wondering if there is a way to disable the checkboxes I don't want and to resize the form to fit the checkboxes I do want. I just don't want a form that looks like it has checkboxes put on it at random spots.

View 3 Replies View Related

Auto Resizing Inserted Pictures To Fit Merged Cells?

Jan 31, 2013

Ive been trying to find a way of inserting a picture into a defined merged cell. Once I insert the pic I would like it to auto size/fit into the merged cells.

I have only managed to do this by either resizing the pic's first, or running a retro macro to resize the image. Just wondering if there was an easier way?

View 4 Replies View Related

How To Stop Rows Resizing With Text Which Paste Into Cells

Sep 10, 2013

how to stop rows resizing with text which paste into cells

View 1 Replies View Related

Chart Axis Resizing Affecting Full Screen?

Mar 26, 2014

My workbook operates in full screen mode simly to make it looks a bit nicer. I have some + - buttons that call a macro to change the scale of the axes of a chart (sort of a zoom effect). For some reason, whenever I run these macros my workbook exits out of full screen mode.

Here's an example of the zoom code:

ActiveSheet.ChartObjects("Chart 115").Activate
ActiveChart.Axes(xlValue).Select
ActiveChart.Axes(xlValue).MinimumScale = 200000
ActiveSheet.Range("a1").Select

View 2 Replies View Related

Lock Aspect Ration Doesn't Work When Resizing Cells

Aug 14, 2014

I imported a picture and changed the properties thus:

Lock aspect ratio is set.
Move and size with cells is set.

If I resize the picture itself, the aspect ratio is maintained - good. However, if I make the column narrower, the pictures width changes, the height remains the same and it acquires a new locked aspect ratio - bad.

View 4 Replies View Related

Resizing Picture Image To Fixed Height And Then Cropped Width

Jan 24, 2014

I'm trying to make this macro work to resize images for our fashion Look Book. In theory, it should work. But of course it does not Here is the code we are using:

Code:

Sub BIGcrop()
Selection.Height = 507.6
x = Selection.ShapeRange.Width
y = x / 2
Z = y - 144

[Code]....

I want all my pictures to have a height of 7.05 inches and a width of 4. The height comes out different everytime depending on the scaling of the template I'm using. I need it to adjust accordingly. I'm open to having the image move into merged cells, as long as it will first adjust the height and then crop the sides (so the orientation stays the same).

View 4 Replies View Related

VLOOKUP Formula Dragdown Copies Previous Cell Result Instead Of Unique Result

Jun 10, 2014

When I drag my VLOOKUP formula down a column in Excel 2010, the return value copies the formula result from the original VLOOKUP formula result. For example, if the first VLOOKUP returns a value of 0.5, I expect to see 0.5 or 1 in the cell below that one. However, I get 0.5 which is not the expected result for the cell below.

When, I click the fx on the cells below, the expected return values appear in the formula result. After I click OK, the expected formula results updates and now appears in the cell.

I'm not sure what is causing this issue. My computer was updated recently from an old machine to a new one. I have never experienced this issue before.

View 3 Replies View Related

Print Result Cards Automatically From Result Sheet

Apr 25, 2014

I have excel result sheet which contains students information. i.e. name, subjects and their corresponding marks, grade, percentage etc. So from that sheet I want to print result cards for each students separately from the data (result sheet).

View 4 Replies View Related

Result Based On Existance: If Coulmn Contains A Anywhere Then The Result Should Be A

Dec 4, 2009

I have 4 categories A, B, C & D. These are in desending importance, means A is most important and D is least important. Now there could be many A, B, C & Ds listed in a column. The challange is if coulmn contains A anywhere then the result should be A. If A is absent, then search for B, if present anywhere then display the result as B. It doesn't matter how many times A or any character is listed in column. I am attaching a sheet for better explanation.

View 4 Replies View Related

Copy Formula Result & Paste Value/Result Only

Sep 3, 2006

I created a simple auto numbering function whereby Cell A7 contained =Row()-6, and Cell A8 contained =(A7+1). I then shift, and pasted the contents of cell A8 until cell A600. My aim is to simply copy the increments of 1 - 600 into another column. However when i copy and paste i'm also copying the initial underlying formula ie: =( A?+1), Is there a way to copy the results, not the formula?

View 2 Replies View Related

Swap 2 Mouse Click Selections After Resizing Selections

Jul 7, 2013

I am trying to take two random Mouse click selections and swap a set of ranges associated with the cells that are selected. For example if the user clicks on A1 it will resize(3,22) and store the selection as a variable to be swapped with another selection. Here is what I have so far but I keep getting a object required error on rngEmp1.

VB:
Sub SwapGroup()
If Selection.Cells.Count < 8 Then
MsgBox "Please Select two Groups to swap. Press and hold 'Ctrl' in between your selections", , "Swap Groups"

[Code] .....

View 4 Replies View Related

Fill In The 3 Criteria Fields, Calculate The Result, Copy The Result, And Place It Into The Correct Place On The Table

Oct 19, 2006

I have a macro that imputs data from an external database and puts it into a temporary worksheet. This data has 3 columns (ID, Date, Amount). I am then making another sheet which has X number of tables (one for each ID), with the years being the column headings, and months being the row headings. ie.

| ID X
| +------+------+------+--->
| | 1999 | 2000 | 2001 |
+------+------+------+------+--->
| Jan | $100 | $250 | $300 |
+------+------+------+------+--->
| Feb | $200 | $300 | $200 |
+------+------+------+------+--->
| Mar | $300 | $250 | $100 |
+------+------+------+------+--->
| Sum | $600 | $800 | $600 |
| +------+------+------+--->

| ID Y
| +------+------+------+--->
| | 1999 | 2000 | 2001 |
+------+------+------+------+--->
| Jan | $100 | $250 | $300 |
+------+------+------+------+--->
| Feb | $200 | $300 | $200 |
+------+------+------+------+--->
| Mar | $300 | $250 | $100 |
+------+------+------+------+--->
| Sum | $600 | $800 | $600 |
| +------+------+------+--->

Currently I have a few hidden fields for the DSUM Criteria. I start making the tables. And then filling in table based off of the month and year. Doing so I need 3 criteria:
>= First Day of the Month
<= Last Day of the Month
= ID #

The problem is it takes Excel too long to fill in the 3 criteria fields, calculate the result, copy the result, and place it into the correct place on the table. Is there another way to get this data into the correct tables faster? Instead of using DSUM?

View 8 Replies View Related

Display Only One Of Each Result?

May 2, 2014

I've got results in row 3 - 16 386 and sometimes these results are exactly the same in some rows. What I now would need is row AB to display only one of each result and row AH to display how many percentages of the time this particular result appears.

View 14 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved