General

filecopy Question
I want to use the filecopy statement to copy a list of files to another folder. This list will be stored in a column on a spreadsheet and will always be different. As such, if the filecopy function encounters an error (like the file doesn't exist), I don't want it to stop the code, but rather identify that ce... 8 Jul 2008 17:13

Print Area to last cell with data
Help, we are constantly adding new data and trying to write a macro (which I am new to) that will set the print area automatically to the last row with data in it. Can someone please help me.... I have no idea what i am doing and the people i am writing this for have less knowledge. Any help would be ap... 9 Jul 2008 19:54

File is slow opening
Hello I'm using Excel 2000, I have a spreadsheet with several sheets and each has a subtotal summary report. Subtotals were done using the Menu selection: Data -- Subtotal -- make selections. Only one of the spreadsheets has a large report, over 30K rows. After I save and close the report if I need to re... 9 Jul 2008 20:56

formula needed for conditional formatting
I need a formula that will highlight the cells in column B if the difference between Column A and B is above 10% and also if the difference in negative and its as high as 10% i want it to highlight. Can someone please help me with this. thank you in advance. A B GM% CURR GM% 68.5 63... 9 Jul 2008 16:48

f2 function key
when i hit the "f2" key in EXCEL, it opens WORD. can anybody tell me why this is happening and if there is any way to resolve this? tnx! ... 1 Aug 2008 09:55

chart size changes in Japanese environment
Hi, My code creates a series of charts into an excel file. I set the width and height of the chart in a manner so that 6 charts will be printed nicely in a row and two rows per worksheet with the just right amount of margin left on either left or right side of the page. This works fine for my computer. How... 8 Jul 2008 16:11

Navigating on a worksheet
Hi, I have a work sheet which I hope to us in my office. All the necessary information is on the screen when the user opens the sheet. Can I prevent the user from panning to the right, I know you can switch off the scroll bars but this doesnt stop the user from panning to the right. Similarly can I prevent the u... 8 Jul 2008 17:13

Nesting a sheet name reference within a cell reference???
I have a simular problem that I can not resolve. I want to reference a cell in another workbook. So if cell A1 contains the name of a worksheet in another workbook. So I would like it reference ,,say cell B2 in "sheet2" of another workbook. e.g. If Workbook 1/Sheet 1/Cell A1 contained "Sheet 2" and Work... 8 Jul 2008 16:11

How stop Excel fm asking to "increase security" when saving?
Excel keeps telling me about new Office Open XML Formats. How can get it to stop?! I don't care if the security level is weak. ... 8 Jul 2008 16:11

Office 2007 Drawing Toolbar
"Irv" wrote: To get to the Drawing toolbar is really inconvienent. Is there a way to put an icon in the quick toolbar? Thanks Irv i need the anwer ... 27 Jul 2008 18:40