My document appears to be only 3 pages but when i print it comes up as a 6 page document and the last 3 pages are blank?

When designing text boxes for data entry, can the text box controls on the UserForm be assigned number formatting properties? For example, how would I arrange...

I'm using Excel 2000 to build a contact list. Several of my contacts have more than one email address and I would prefer to put all email addresses for an...

I couldn't get a reply in excel programming group, hopefully here? - If I open a local file my shortcuts, to run macros, work fine but if I download a file...

Is there any way in which coloured rows of data can be sorted / grouped dependent upon their row colour? Regards Tony --- Message posted from...

I've made a fax sheet in excel with a number of blocks to be filled. Company name, ph#, fax number, part #, etc. All this information is present on another...

I have created a program in Excel to generate quarterly reports. The user fills in a daily worksheet (a template) and adds the entry to a database record. ...

Hi, The Last name column has uppercase and lowercase letters. I would like to make them become all uppercase letters.( First letter, not whole word) Ex:...

I use following Syntax which works very well: sumif(c4:u620;e777;w4:w621) the cell "e77 " is the criteria how can I summarize when I use two criterias? For...

I have entered the formula in my cell, and I want my result to be rounded to the nearest multiple of signifiance (for example 5). I have tried with function...

Hi Does anyone know if there is a way to pick up the sheet name in a cell? Thanks Shona

I have an excel workbook that is 65295kb i would like to speed up what ever i action i choose, as you can imagine a workbook of that size when i make a...

Hello everyone, In order to allow a macro to be actionable throughout a workbook (from every sheet). Where is the best place to store the code? In Modules,...

Hi A user of ours has a problem when viewing his spreadsheets. The spreadsheets are quite large and are colour coded. When he opens them on his machine he...

I would appreciate help in resolving the following problem Column A ColumnB Column C Column D r1 y04 ...

Dear All Any clue why the pivot table is still remembering old data? I have a field where I have names and numbers as data... For some reasons, the numbers...

Hi I have say 5 charts on a worksheet and 5 buttons on another worksheet with each button assigned a different macro. The macro will bring the user to its...

I am working in excel and I need to prevent sub total rows appearing in my pivot tables. Does any know if this is possible and if so how? Also, I am working in...

this is code i have created Sub Button2_Click() Dim d As Range Dim LookupRange As Range, cell As Range, Found As Boolean Dim DestRange As Range Dim prst As...

How do you write a macro that specifices the largest number result in a range of values? --- Message posted from http://www.ExcelForum.com/