Programming

Verifying a worksheet has no dependants
I am dealing with a large workbook, created by soeone else - i'm sure many of you have been tehre. Anyway, it seems to me that many of the worksheets contain unused functionality. What would be the best way to determine if no other worksheets were dependant on one worksheet in particular. I thought about us... 27 Jul 2008 10:26

macro to enter data into different line
i have a few data in different line.. and want copy all the data into new sheet using macro. and for next data I wanted the macro to copy to a new line (empty line / next line after first copied data). Let say i click copy button 3 time the data will insert into new sheet in continues line and not replace the s... 23 Jul 2008 05:05

How to write FIFO Function in Excel programming
Appreciated if someone can help me on the problem on how to create / write VB code in excel for FIFO function on my stock valuation purpose. and pls mail to :- chchng(a)transmare-Chemie.com ... 22 Jul 2008 06:31

web box address
Hi how do I return a web browser address into a cell as per the following example?? Cells(ActiveCell.Row, "ar").Value = ActiveSheet.Shapes("WebBrowser2").Address ... 25 Jul 2008 15:34

Solved: Copy & Paste from one Worksheet to another without givingfocus?
Found it: ' ******* Dim wb As Workbook Dim oldWs As Worksheet, newWs As Worksheet Set wb = Workbooks(filename & ".txt") Set oldWs = wb.Worksheets("myWorksheet") oldWs.Columns.AutoFilter 4, "<>0" ' only display where colum 4 <> 0 oldWs.Name = "dummy" ' rename old worksheet to temporary name wb.Worksheets... 22 Jul 2008 03:27

Re-setting Forms Spinners or Combo-Boxes
Thanks. This is helpful to me as well. "Incidental" wrote: Hi Marie You can reset both combo and listboxes by setting their list index to -1, putting the code below in the code for the reset button or userform_initialize event (depending on which option you went with from above) should do the tr... 22 Jul 2008 03:27

value in range
What is the fastest way to check if a range contains a specific value? ... 22 Jul 2008 03:27

Copy & Paste from one Worksheet to another without giving focus?
My next problem: I currently have this code to "delete" unwanted lines: ' ************************** Dim wb As Workbook ' wb for workBook Dim ds As Worksheet ' ds for dataSheet Set wb = Workbooks("myWorkbook") Set ds = wb.Worksheets("myWorksheet") ds.Columns.AutoFilter 4, "<>0" ' only show data where colum... 22 Jul 2008 03:27

track changes
hi, does anyone know if it is possible to write a marco to track the changes in an excel document? if so do you know where i could find some information on this or help me write this. i want to create a function button that will create a new page to display all the changes made to a document in say the las... 22 Jul 2008 11:39

search for capital letter at end of text string
I need to search for a word with a capital letter at the end of the string. For example Hydrochloric acid 1M Ive tried using =IF(RIGHT(D18)="M","yes","no"), but it doesnt differentiate between lower case and upper case. Can anyone help? Thanks, Roger ... 22 Jul 2008 00:23