Programming

missing Application.FileSearch excel 2007
What do you use instead of the missing Application.FileSearch? Thanks John ... 13 May 2010 22:41

Negative to zero code
I went in and formatted a cell to: 0;"0";0 so that all negative numbers will be converted to zero. I have a textbox on a userform that I need to do the same thing. What code would I use? I tried this but it doesn't work: txtRemain.Value = Format(txtRemain.Value, "#,#00;""0""") Any help would be greatly appric... 13 May 2010 23:47

Help to find and replace between sheets
Hi all, i have 2 sheets as below column c J row 6 511 285 row 7 285 row 8 422 625 sheet2 col b m row 100 510 row 105 511 285 row 120 282 row 125 285 row 800 422 625 find sheet1 511 and 422 in sheet2 (because value next to them is >... 14 May 2010 00:52

Going through Named Ranges in only specific Sheets in my WorkBook
Hi all! So, having trouble with ranges... I can't seem to get right a way to run through Named Ranges that belong to only a given Sheet...and then do stuff to them. Any ideas?? '--------sub beg------------- Sub LoopThruRanges() Dim rng_names As Variant Dim n As Variant Set rng_names = ThisWorkbook.N... 13 May 2010 18:17

Get a list of open workbooks and choose one
Hello, I need to get a list of all the workbooks that the user currently has open, give that list to the user, let them select one, and then Activate that selected workbook and continue with processing. I can generate a list of workbooks in a given directory, but the requirement here is to get a list of wor... 2 Jun 2010 16:30

Converting a “Delete Column” Macro to a “Delete Row” Macro
Hi there You are close. In de code fragment Cells(a,b) the a refers to the row number and the b refers to the column number. Try: Sub DeleteRows() ' ' DeleteRows Macro ' ' Keyboard Shortcut: Ctrl+Shift+F ' Dim WS As Worksheet Dim DeleteThese As Range Dim LastRow As Long Dim R As Long For Ea... 13 May 2010 20:30

Sorting help !!!!!!!!!!!!!!!!!
I keep getting a "Application-defined or object-defined error" with the code below. I am tring to sort by columns B, C, D and I. Row(4) has the Header for the data range. I am using Excel 2007 but people with Excel2003 need to be able to use it too hence this sorting code. What am I doing wrong here? Help!!!... 13 May 2010 17:10

See if cell is in Range
Thanks for taking the time to read my question. I'm passing a string that is a cell reference to a function. In that function I want to determine if that cell reference is within a predetermined range. Not sure how to do that. Right now I have: Function CheckRange(TheSheet As String, TheCell As Range) As Bool... 13 May 2010 16:03

challenging sumifs?
Need to sum columns x,y,z on another sheet by criteria on the original sheet. So sum columns x,y,z from sheet Detail --- 100 rows, x1:z100 - the sum range. Via criteria range on sheet Detail - a1:a100 Where the Detail sheet row matches [lookup?] criteria on sheet Summary k12. Have looked at it too lon... 13 May 2010 16:03

Print all tabs to a pdf file
I need a macro that will print all of the worksheets in an Excel workbook to separate pdf files for each tab. I would also like to name the pdf file as the name of the tab. How can I accomplish this? ... 13 May 2010 16:03