Programming

Advanced filter with naming range
Hi, I need to copy all the data from SheetB with ENV_342 criteria to SheetA. I am using the advanced filter. In this code I am using the range A5:B911, but I need to replace this by FILTER naming range. If I just replace the text “A5:B911” with FILTER I received the execute error message 1004. Do anyone ... 20 Jul 2008 12:28

Delete and Shift Cells up
Hi all, I'm trying to create a macro that will start at the very first cell, I guess A1, and work it's way down, and will check the value of the cell. If the value of the cell is not equal to the word "Sales" then delete that row. but if it finds the word sales then stop the process. Also can I have this macro ... 16 Jul 2008 17:11

Can you formulate a cell to add and subtract in the same cell?
I have a subtotal and the next cell could be either an addition or a subtraction from the subtotal. Can you do this with a formula? ... 16 Jul 2008 13:01

Reference/define last cell
I need to define a formula in cell M1 similar to: If the Last Cell in column M = 0, use the value from the row above in column M, otherwise use the value of the Last Cell in column M. For example if the last cell in Column M was in Row 100 the code would read Range("M1").Select ActiveCell.FormulaR1C1 = IF(M100... 17 Jul 2008 11:40

TRANSPORTATION PROBLEM
Hi, I have used Solver for transportation problems earlier for smaller number of variables and contstrains. However, today while trying to solve a transportation problem for a bigger set of variables, i am getting an error message "TOO MANY ADJUSTABLE CELLS" Can some one help me solve this problem on excel? -... 16 Jul 2008 13:01

ShowModal, Hide Form, Print Preview Office 2007
Hi There, I'm trying to get print preview to work from a form in office 2007. The form needs to have showmodal=true. In previous versions of offce I could hide the form, then open print preview and everything would work. In 2007 I hide the form, open print preview and all the buttons are grayed out. If I set ... 4 Aug 2008 17:45

preventing access to hidden worksheets
I have hidden worksheets on my program. How can I prevent someone from unhiding a worksheet? I know how to protect the worksheet from changes but there are certain worksheets I want to keep from others eyes. Thanks Glenn ... 16 Jul 2008 14:03

HOW TO MERGE TWO MACROS
Hi all , I have macro (see below) from which I am taking sort of work of progress bar and it works fine Macro 1 ================================================> Public RunWhen As Double Sub StartBlink() If Range("N4").Value = "UPDATING PLEASE WAIT." Then Range("N4").Value = "UPDATING PLEASE W... 16 Jul 2008 11:58

limiting number of uses
I have a program I am going to send for review. My question is how can I set up the workbook to not allow access after a certain number of times the program is opened or how can i limit the number of days the program can be accessed? Thanks for you help Glenn ... 16 Jul 2008 17:11

Chronological Numbering Spreadsheets
I have 30 spreadsheets in one file, and would like to chronologicaly number them (have a certain cell display the number of that spreadsheet). I don't want to have to go to each spreadsheet and write a formula linking that spreadsheet to the previous one. Is there a way to have the cell in each spreadsheet look... 16 Jul 2008 17:11