Hi Guys - back again ! I have created a fully formatted VBA data entry form with relevant combo boxes; labels etc etc. I hav a command button to close the...

Thanks.This solution worked for me. I tried to use the value function but it gave me error -AVERAGE(value(I2):value(I12626)). Any idea ? -- ARASKAS "Bernie...

Excel 2003/SP2, running under Windows XP seems to take forever to calculate a formula when it is copied to a new cell. My computer is a P4/1300 with 768MB...

In my pivot table I tried to right click the "Date" column in order to group by month. A message popped up "Cannot Group that Selection". Is there another way...

I set my macro up to run on multiple spreadsheets. Unfortunately, the macro functions are performed for the number of lines in the original spreadsheet. ...

Dear All, While in filtered mode copying cell that consists formula and converting them into values yield as following error. Copy and paste area are not...

Hi everyone and thanks for any help you can give. One of you guys always has the answer I need. I'm running XP Pro and Office 2007. I have one directory on...

How do I prevent others from changing the format of the header and footer. I tried protecting the sheet but people are still able to edit the header and...

I'm trying to find out if there is a way to eliminate the select (All) option in a report filter--so that you can only select 1 of the other filter names at...

I'm using excel 2007 and when I use the "/" it acts like the alt keys. Is there a way to turn this feature off?

I know how to sort data by number and alphabetic. But I have a color coded document that I would like to sort by color. Can I do this without adding...

I have data from an SQL WBC-A. When I pivot this data it returns ` (The character below the tilde) Any other data returns the correct pivot. E.g. WBC-X...

Hi I have protected a worksheet but when I scroll up too far up to the top or too far left instead of stopping there it takes me of to a different part of...

I have several Macro's thst toggle on/off see example text line on/off below Sub text_wrap() ' ' text_wrap Macro ' Macro recorded 3/24/2008 by Raytheon ' ...

Hello.. I have one lists of number in A1:A7 and a list of words in B1:B7. I need to find the highest, second highest and third highest value in these lists...

while im try to type numbers numbers like 12/6 in some cells, its automatically converting to data format like 6-Dec, how can i avoid this? -- anipriya

how do I increase the size of the clip board up from 24 clips

No longer when I open a new spreadsheet in Excel 2003 does my number format defaults to general but with an odd formatting. When I enter a number(example...

I want to place some code at the start of my macro. If D34 = no then a message box "Your printer code doesnt match" end macro else yes run the macro. Please...

HI I have created a form via VBA, I have included a combo box which I want to point at a specific list of entries. I can do this on a normal worksheet using...