Excel BUG in macro recording (every version)

I have found a bug in every Excel version, where can i post it?

1) Start recording a new Macro
2) Go to Print Preview
3) Adjust a margin
4) Stop recording

The macro contains errors because it has empty parameters for the margins:

With ActiveSheet.PageSetup
        .LeftMargin = Application.InchesToPoints(0.84)
        .RightMargin = Application.InchesToPoints()
        .TopMargin = Application.InchesToPoints()
        .BottomMargin = Application.InchesToPoints()
        .HeaderMargin = Application.InchesToPoints()
        .FooterMargin = Application.InchesToPoints()




0
elioml (3)
10/12/2003 2:20:16 AM
excel 39879 articles. 2 followers. Follow

3 Replies
620 Views

Similar Articles

[PageSpeed] 56

w

From XL2003

..LeftMargin = Application.InchesToPoints(0.78740157480315)
..RightMargin = Application.InchesToPoints(0.78740157480315)
..TopMargin = Application.InchesToPoints(0.78740157480315)
..BottomMargin = Application.InchesToPoints(0.78740157480315)
..HeaderMargin = Application.InchesToPoints(0.590551181102362)
..FooterMargin = Application.InchesToPoints(0.590551181102362)

I cannot test earlier versions as I don't have them, but I suspect it is
only recording the change.  I changed all of them for the above.

-- 
HTH
Nick Hodge
Southampton, England
nick_hodge@btinternet.com


"w" <elioml@telpress.it> wrote in message
news:OkKoddGkDHA.2536@tk2msftngp13.phx.gbl...
> I have found a bug in every Excel version, where can i post it?
>
> 1) Start recording a new Macro
> 2) Go to Print Preview
> 3) Adjust a margin
> 4) Stop recording
>
> The macro contains errors because it has empty parameters for the margins:
>
> With ActiveSheet.PageSetup
>         .LeftMargin = Application.InchesToPoints(0.84)
>         .RightMargin = Application.InchesToPoints()
>         .TopMargin = Application.InchesToPoints()
>         .BottomMargin = Application.InchesToPoints()
>         .HeaderMargin = Application.InchesToPoints()
>         .FooterMargin = Application.InchesToPoints()
>
>
>
>


0
nick_hodge (41)
10/12/2003 8:52:16 AM
Which way did you change the margins?  Graphically from the Margins 
button, or numerically from the Page Setup button?  In 2000 and XP, the 
graphic approach fails to record values that were not changed, resulting 
in code that will not run.

Jerry

Nick Hodge wrote:

> w
> 
> From XL2003
> 
> .LeftMargin = Application.InchesToPoints(0.78740157480315)
> .RightMargin = Application.InchesToPoints(0.78740157480315)
> .TopMargin = Application.InchesToPoints(0.78740157480315)
> .BottomMargin = Application.InchesToPoints(0.78740157480315)
> .HeaderMargin = Application.InchesToPoints(0.590551181102362)
> .FooterMargin = Application.InchesToPoints(0.590551181102362)
> 
> I cannot test earlier versions as I don't have them, but I suspect it is
> only recording the change.  I changed all of them for the above.

0
post_a_reply (1395)
10/12/2003 11:25:21 AM
Graphically, if i set the margins manually it works, but if i do it from the
preview
every excel version (2003 as well) has this bug.

Elio



----- Original Message ----- 
From: "Jerry W. Lewis" <post_a_reply@no_e-mail.com>
Newsgroups: microsoft.public.excel
Sent: Sunday, October 12, 2003 1:25 PM
Subject: Re: Excel BUG in macro recording (every version)


> Which way did you change the margins?  Graphically from the Margins
> button, or numerically from the Page Setup button?  In 2000 and XP, the
> graphic approach fails to record values that were not changed, resulting
> in code that will not run.
>
> Jerry
>
> Nick Hodge wrote:
>
> > w
> >
> > From XL2003
> >
> > .LeftMargin = Application.InchesToPoints(0.78740157480315)
> > .RightMargin = Application.InchesToPoints(0.78740157480315)
> > .TopMargin = Application.InchesToPoints(0.78740157480315)
> > .BottomMargin = Application.InchesToPoints(0.78740157480315)
> > .HeaderMargin = Application.InchesToPoints(0.590551181102362)
> > .FooterMargin = Application.InchesToPoints(0.590551181102362)
> >
> > I cannot test earlier versions as I don't have them, but I suspect it is
> > only recording the change.  I changed all of them for the above.
>


0
elioml (3)
10/12/2003 4:13:58 PM
Reply:

Similar Artilces:

Create business form in Excel
I am a long time user of basic Excel functions. My employer would like to create Estimate/Proposal forms in Excel. I am not sure how to have some parts of the worksheet display with grid lines, and have other areas on the worksheet display without grid lines. If there is a video tutorial and you can send me a link that would be greatly appriciated. I do know how to merge cells and outline cells. I have been trying to figure this out for myself for the last week and have become frustrated. Thank you in advance. -- maagk Most of the people who respond to questions in these news group...

how to change the icon of excell 2007 into other one
pls do advice me to change the icon of excell,Thank you Right click the icon and select properties. In short cut tabs find in "Change Icon" box in the middle bottom. Click and continue -- R. Khoshravan Please click "Yes" if it is helpful. "Mystery" wrote: > pls do advice me to change the icon of excell,Thank you ...

Excel 2003 won't open spreadsheet with a chart
When a customer tries to open a spreadsheet with a chart, he gets the error, "Microsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience. The information you were working on might be lost. Microsoft Excel can try to recoved it for you." If he tries to recover, the sheet opens and the data is there, but the charts are blank. Spreadsheets without charts open with no problem. Identical computers on the network can open the spreadsheets he can't, and he created them. This just started today. He has tried rebooting and moving the file...

Need an Excel formula
Hello, Can someone please tell me how to make a formula in Excel that can calculate 20% multiplied by (Gross pay) minus dependance, multiplied by 38.46. -- Looking for nothing, yet searching for everything. =((gross_pay*20%)-dependence)*38.46 change the names with the cells holding the values. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Kirschwasser" <azureferal@yahoo.com> wrote in message news:FF4ACBC1-C8F8-4F98-A3F6-3DEEC7DB43C8@microsoft.com... > Hello, > > Can someone please tell me how to make a formula ...

way to subquery for next record in query?
I've got a query (qryMaingroup) that looks at a table (tblMain) and displays all the records in tblMain with a seat number less than a particular value. I'd like to query that query to find the first record that has a seat number which adding 1 would mean that the next record in the original query is not equal. In other words if the first query returns all those in tblMain with tblMain.Seat less than 13, the second query returns the lowest Seat value from the first query where tblMain.Seat + 1 < tblMain.Seat from the next lowest value in that first query. I think ultimately...

Listbox row source and record locking?
I'm setting up my first true multi user database and I have a question on record locking. If I set a list box row source type to "table/query" and specify a select query for it, does Access lock those records? In the past I have always used "value/list" and loaded the records with code but it would be much easier to use ""table/query" if it does not lock the records. In most cases, Access only locks an editable record. The select statements in list and combo boxes do not lock the table because you aren't editing those records. ...

Creating records in one file whilst editing another file
I have a simple form which allows updates to records in an employee file. Each time a record is changed I would like to create an audit record in a separate file. I do not need any input from the user when creating the record as all the information is implied (date, time, user, before and after values etc.) I would be interested to know what people think the easiest way to do this would be...?? All opinions welcome - the more the merrier. Thanks, Jon. 88Caddy wrote: >I have a simple form which allows updates to records in an employee >file. Each time a record is changed I would ...

HELP: Excel changed all my hyperlinks A:
Help For some reason Excel went and changed all my hyperlinks to point to my floppy drive a:\ -WHY? Is there any way I can automatically remove the a:\ hyperlink references, manually renaming is going to take ages. Excel's replace function doesn't seem to work with hyperlinks :-( -Arska Hello Arska, Have you tried find and replace? Press ctrl+h Find what: A:\ Replace with: C:\My Documents (assuming this is where the file you want to link) Then hit Replace All or if your using xl 2002 you can go to EDIT|links then hit change source Hope this could help Jon-jon "Ars...

Data in several long "records" rather than fields
Hi. I am trying to analyze a client's sales data in Access but it was provided in an tab deliminted top-to-bottom format rather than right-to-left. E.g. there are sales amount in the first record, tab delimited out for all transactions; cost of materials in the second record; invoice in the third record; etc., etc. I need these to read as fields - can anyone give me a solution to my quandry. Thanks in advance. Mike -- Mike Barbosa KPMG International Tax Services I'd import it into Excel and analyse it there. At the very least, it will be easier to sort and output a reformat...

ChartObjects Insanity
Either one of us - me or Excel - is insane, or soon to become so. I have code I'm trying to convert from Excel 2003, and it's not going smoothly. Here's the current problem. I have a workbook with a number of chart sheets, each containing three charts. I want to delete the third chart from every sheet. I used to say.. For Each ch In wb.Charts ..... ch.ChartObjects(3).Delete Next ch Now, that tells me I have a subscript out of range. I check, and ? ch.ChartObjects.count returns a value of 3. I can return the name on the third chart too, so I try ch.ChartObject...

how to record the return of principal when a bond matures
I have a bond investment that matured on Jan 1 2008. The principal amount has now been returned to my bank account. How do I record this in my investment transactions? -- Cheers. Christian There is a Return of Capital investment activity... "Christian" <Christian@discussions.microsoft.com> wrote in message news:75CA3A95-DB74-447D-9C66-E618DA9E53C9@microsoft.com... >I have a bond investment that matured on Jan 1 2008. The principal amount >has > now been returned to my bank account. How do I record this in my > investment > transactions? Thanks. I have...

Conditional sum wizard problem--Excel 2000
This is driving me crazy. Can anyone explain why this won't work with the Conditional Sum Wizard? I've used the wizard many times before and can't figure out why it doesn't work this time. Category Price Paid? Core $55.50 yes If I try to sum "Price" using the criterion Paid?="yes", it works fine (i.e. I get $55.50). If I try to sum "Price" using Category="Core", it doesn't work (I get $0.00). Both "Category" and "Paid?" are formatted as text; "Price" is formatted as currency. Thanks. Hi ...

Using bookmarks to select a record after form requery
I have a continuous form in an ADP linked to a SQL view. The view contains both ordering and filtering. The form is designed to display invoice lines... Some items in the invoice are grouped under a parent, and the parent line denoted by a field itemParentID, pointing to the primary key of the parent line. One field on the form is a price. When changing the price on a part which is from a group, the overall price gets updated, and vice versa. This happens in a stored procedure. What I want to happen, is that in the OnExit event for the price text box, the stored procedure is called, the form...

Upgrading from GP version 9 to version 10
We are currently running GP version 9. Does anyone know any of the major advantages of upgrading to version 10. Thanks Alex, There are several advantages of upgrading to V10. First, in terms of UI, there is a big difference. You can take advantage of much advanced Field Level Security. You have features like Reconile Payables to Receivables to GL, Inventory Trial Balance that also acts as tie-out of inventory to GL Report and so on. There are several other advantages besides these. -- Thanks Janakiram M.P. MCP-GP http://janakirammp.blogspot.com "Aelx" wrote: > We ...

Smartlist unable export to word or excel
Hello, The exact error message I get is as follows: SmartList is unable to send data to another application. Could not find file :C:Dynamics/EXP1493.exe Now this box pops up after i try and click the export to Excel or Word button in the smartlist window. The filename seems to be wonky as i did a search ont he server for a EXP1493.exe and found nothing, also looked at a dated backup of the program folder.. no Exe's with that filename. The path looks weird to me though but i will admit i don't have much experience digging into the workings of this program. We are running GP...

An earlier version of Pubisher had bridge tallies. Now?
Publisher 97 had bridge tallies. Where can you get the template for them now. Can I move the template from Pub97 to Pub 2003? If you have Publisher 97, open the tally template, save as... Publisher 2003 will open the file. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "Beachman" <Beachman@discussions.microsoft.com> wrote in message news:9A8BF3FA-501E-488F-8A56-FFD02A36CC58@microsoft.com... > Publisher 97 had bridge tallies. Where can you get the template for them now. > Can I move the template from Pub97 to...

Excel printing problems with macros in spreadsheet
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I have an older printer (Xerox Phaser 5400) which has been a work horse. I have just purchased a new iMac that has Leopard on it. Now, my spreadsheets that were made in 2008 Excel won't print to the Xerox if they have macros in them. Anyone have a fix on this? I uploaded the driver AGAIN from Xerox website and it doesn't fix the problem. > This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --B_3347691155_512...

Excel using =RC[-1] format and I don't want it
On this machine only, Excel will use the format =RC[-1] when I am entering a formula on the command line by hand and click on a cell to reference it in the formula. I don't know how this got on but I would like it to go off. On my other machines, it does the old familiar A1:B2 style of cell reference. I can't even search for how to fix it since I can't determine what this is called so I can turn it off. The only reference I have seen is a button that is only effective for macro creating and I am not creating a macro, just a formula, interactively, in the cell. How ...

How do I only show a range of columns/rows in Excel?
I only want to view, say, columns A thru K and rows 1 thru 23. Even if I scroll, I still don't want the sheet to go out of that range. Hi Larry Insert the following code into a module in the workbook. Press Alt+F11 to bring up the VB Editor. Insert>Module and paste the code below into the module. Change the sheet name to your sheet name if it is different to Sheet1 Sub Auto_Open() ThisWorkbook.Worksheets("Sheet1").ScrollArea = "A1:K23" End Sub Regards Roger Govier Larry Zukerman wrote: > I only want to view, say, columns A thru K and rows 1 thru 23....

Validation in Excel Sheet
Hi, I have an EXcel sheet, where in i have 2 spread sheets.The first one i display sheet where i want to get the values displayed from the secon one which has all the data. Example: When the user enters an EMPLOYEE NO, the Excel sheet has to search fo the EMPLOYEE NO stored as a list in the second spread sheet, and i found display all the details say his address,phone no etc.If not foun it should display "NOT AVAILABLE" So i need t write a formula, where in it validates the EMPLOYEE NO i the first spread sheet with that of the second spread sheet(which has long list of EMPLOYEE N...

open up excel in quattro pro?
I received an .xls spreadsheet. I don't have excel. Can I open it using quattro pro? DO I change the extension to .qpw? How do I open it? Never mind ladies and gents - I tried it and it worked. I got impatient. Sorry for any inconvenience. Zhawk "zhawk" wrote: > I received an .xls spreadsheet. I don't have excel. Can I open it using > quattro pro? DO I change the extension to .qpw? How do I open it? ...

Excel graph 3 sets of data. 2 sets as lines 1 as column?
I have data a bit like below, I am trying to do a graph, which shows the AFR as columns for A-D, but I want 'water' and 'whole' as seperate lines to show current scores across the graph. When I do the graph, I get two columns and 1 line. Does anyone know how to get to get the two lines? A B C D AFR 0.8 0.6 0.4 0.3 Water 0.5 0.5 0.5 0.5 Whole 0.3 0.3 0.3 0.3 Hi AndyN, On the chart, select the second column, right-click, select Chart Type from the context menu, select line chart. Ed Ferrero www.edferrero.com Ed Thanks for that worked a treat, I'll remember that ...

Creating a Macro Button to Extract Data
Hi All, I have an Excel Spreedsheet & within this there are Two sheets. 1 Summary & 2) Original Data. What i would like to create is a Macr Button that will be on the Summary Sheet & once i press this it wil bring Data from Sheet Original Data only the Business Centre Nam highlighted in Yellow & only the Sick Highlighted in green & the FT Figure which is in Coloumn B. Would appreciate all the help. Attache is an example sheet on what the data looks like. Cheers Wil +------------------------------------------------------------------- |Filename: Book23.zip ...

excel e-mail file
i rcvd an e-mail with an excel doc. attach. i do not have microsoft excel on my computer. is there any other program that will open an excel doc. >-----Original Message----- >i rcvd an e-mail with an excel doc. attach. >i do not have microsoft excel on my computer. >is there any other program that will open an excel doc. >. >never mind, i was able to open it with microsoft access. Hi there is a free Excel viewer available at http://www.microsoft.com/downloads/details.aspx?FamilyID=4EB83149-91DA- 4110-8595-4A960D3E1C7C&displaylang=EN HTH Frank anonymous@discussions.m...

Excel 2000 #28
How do I rename column header in Excel 2000? For example: From "A", to "song Title". Hi, Tez; I don't think you can do that. Put "song title" in the top cell of the column, instead. Regards, IanRoy "Tez" wrote: > How do I rename column header in Excel 2000? > For example: From "A", to "song Title". > Hi Tez As IanRoy said, put all of your Headings in row A and then Goto Tools/Options/View and Uncheck the Row & Column Header box about halfway down the page HTH Michael "IanRoy" wrote: > Hi, Tez;...