Programming

circular reference
I have one cell for total time and another cell for total downtime. When a user enters a number into either total time or into downtime i need to automatically subtract the total downtime from the total time. The problem is circular reference as the user has to enter the value into total time before the calcu... 18 Jul 2008 07:12

Repeat a macro until the last line is empty or repeat it 1400 time
I have done a macro that insert 20 lines, do some copying exercises and stops 1 line down the insertet ones. Instead of repeat the command run for about 1400 times I like to configure a "loop" that runs this macro until there's no more lines to copy. Another solution could be to repeat the macro 1400 times, may... 18 Jul 2008 05:09

Entering Userform data to worksheet
Hi Guys, I have a user form that I am hoping will simplify data entry onto a large wooksheet. The user form logs growth measurements. Individual measurements will always be entered onto the worksheet in the same row (i.e. weight = r12, height = r22, sitting height = r23). There are various calculations inbetw... 18 Jul 2008 07:12

Cell invisible when printed.
Is there a way to have a cell visible on screen but invisible when printed? ... 18 Jul 2008 06:11

code to automating digital sign
Hello! I would like to make a program to digital sign a lot of created excel with macros. I only find there example, but is not enough: Public Function IsWordProjectSigned(strDocPath As String) As Boolean Dim docProj As Word.Document ' Open document. Set docProj = Documents.Open(strDocPath) ... 18 Jul 2008 04:08

transposing data in excel worksheet
I have 1200 excel 2003 worksheets in the following configuration Town1 Town2 Town3 Town4 Date Date Date Date Salesperson sales n1 sales# n2 sales# n3 sales# n4 sales# I wo... 18 Jul 2008 02:06

Simplest Question
Hi everyone I have this macro below that creates charts automatically and it works so far with no problems. I have 4 sheets Sheets("V","$","RU","Chart") Currently all the charts gets created below the actual data sheet "$". Q: How do I alter or add to this macro in order to make the chart in sheets("Chart") i... 18 Jul 2008 03:07

Tab Selection
I'm using Excel 2003 and wondered if there Is a quick way of selecting a tab where at least 40 tabs exist in a workbook. i appreciate that i can select the scroll arrows but this shows a pop up whereby i have to select more sheets and then i have to scroll through the lsit to select the tab i require. Is there a way... 18 Jul 2008 08:13

Quickly Tab Selection
I am using Excel 2003 and i wondered if there was a way to quickly select the tab i needed within a workbook where there are over 40 tabs. I appreciate i can right click on the scroll arrows but this opens up a box whereby i can view only a small seelction of the tabs...i then have to select more sheets and then... 18 Jul 2008 16:31

listbox remove
Can I ask for some help for removing an item from a listbox? I wish to add a remove item button. the listbox is lb1 and the sheetname name it is rowsource to is checkout range a2:d15 Thanks in advance Greg ... 18 Jul 2008 09:15