Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. DaleWatson123321

    Installation of Lotus 123 Version 5

    Hi "Caveman 123", I have a suggestion that "might" be useful. dalewatson at mts dot net
  2. DaleWatson123321

    program freezes

    This is from a previous posting. Hopefully it will help. SOLUTION FOR LOTUS 123-R5 FOR USE WITH WINDOWS XP I've been able to get Lotus 123-R5 working completely without any problems whatsoever - in Windows XP. Try the following steps: 1) Create a desktop shortcut for loading Lotus 123-R5...
  3. DaleWatson123321

    Missing print and preview icons

    I only have release 5.0, but in case the steps are similar to your version, try (from the menu)... Tools > SmartIcons I hope this helps, Regards, Dale Watson
  4. DaleWatson123321

    Excel Find Data Problem

    Hi Michelle, Enter this formula in an adjacent column (C for example), and copy down. =IF(COUNTIF(B:B,A1),A1,"") It will test the value in column A, and if it exists anywhere in column B, it will show the value (in column C). And if the value does not exist in column B, the formula will show...
  5. DaleWatson123321

    Complicate Sum(If) Arrays Slow

    Will, Perhaps where there's a "Will", there's a Way ;-) I've been using the power of Excel's "database formulas" for some time, and can confirm that they are SUPER fast. There is a bit of a learning curve, but you might find the time investment worthwhile. Setting up database formulas is not...
  6. DaleWatson123321

    can't remove 'fill' colour from cells

    Hi, Have a look at Conditional Formatting. From the menu, it's under "Format". A quick way to get rid of the colors would be to: a) format a cell with the formatting you want, b) Copy the cell c) click on the columns, d) Paste Special - Formats. This will leave your current formulas/values...
  7. DaleWatson123321

    sorting named ranges

    Craig, It's always good to experiment / explore by recording macros; however, you'll likely find the following useful. Please Note: If the ranges include field names, then you'll need to change the rows that reference the Header - i.e. change "Header:=xlNo" to "Header:=xlYes". From your...
  8. DaleWatson123321

    Excel crash - can you reproduce it?

    Hi Skip, great to see you're still doing well. ;-) I can't see a Business Case, either; however, it's "kinda neat" to know of this. Now I'll know NOT to do something "dumb" like... bet against someone who claims they can consistently crash Excel with ONLY 4 keystrokes and a click-of-the-mouse...
  9. DaleWatson123321

    adding numbers in excel

    Slight "assist" required ;-) ... John's instructions are close but are not really demonstrating AutoFill - because in effect only the formula gets copied. * In A1, enter 15000. * In A2, enter 30000. ( or alternatively you could type =A1+15000, hit the "Calc" key <F9> to convert to a value...
  10. DaleWatson123321

    convert excel print area to image

    You might also want to check out faq68-1161. Regards, Dale Watson
  11. DaleWatson123321

    Extract Calculated Value from Excel Cell

    Hi Spunky, With VBA, it should be as simple as Sub Get_Value() Dim val As Double val = [A4].Value MsgBox "Value is: " & val End Sub A preferred method, however, is to reference a cell that has been assigned a "range name". This way, if the sheet gets modified, then you don't have...
  12. DaleWatson123321

    Excel VBA - Selecting a Row

    combo, Nice addition ===> STAR Regards, Dale Watson
  13. DaleWatson123321

    Excel VBA - Selecting a Row

    Dee, I occasionally get an opportunity to help Skip. :-) Where Skip refers to "ButtonObject", he means for you to replace "ButtonObject" with the actual name of the button. You can identify the name of the button by right-clicking on the button, and looking in the "Name Box" (top-left-corner...
  14. DaleWatson123321

    Copy n Paste non-contigous columns

    Excel's "Advanced Filter" is a powerful component that is often overlooked. One of its many "powers" is its ability to extract data - whatever data you require... by way of the criteria you specify. - AND you can easily pick WHATEVER COLUMNS you want, - AND you can place the columns in...
  15. DaleWatson123321

    need macro to insert a blank row between every 2nd row of data

    Hi Jaffey, This should help. I can appreciate that while the results one gets from recording a macro are helpful, there is MUCH more in-depth knowledge one needs to gain (in order to create an effective piece of code). Sub Insert_Rows() 'Inserts row every 2nd row. 'Place cursor on top row of...
  16. DaleWatson123321

    Determine Excel Row Height without VB code

    Jim, For me, the easiest method of creating sheets with IDENTICAL row-heights and column-widths... 1) If different data already exists on the "destination" sheet (the one to be made the same as the "template" sheet, then copy the data to a separate (temporary) sheet - for later copying back...
  17. DaleWatson123321

    Making worksheet function to strip a cell of non number characters.

    I like it. I like it. ;-) Thanks Skip and John. Stars to you both. Regards, Dale Watson
  18. DaleWatson123321

    Excel Need to copy phone number from a cell stripping non number chars

    Another option... =LEFT(A1,3)&MID(A1,5,3)&MID(A1,9,4) This will eliminate ANY characters, but unlike John's Substitute function, this requires that the characters to be stripped are in the SAME position. You've probably got John's formula working, but in case not, here's a (slightly) modified...
  19. DaleWatson123321

    First time rendering a 1 hr video, need help with compression and bars

    Akribie, I was "browsing" and noticed the VERY significant contributions you've been making regarding Premiere - and I feel it's also VERY important to show appreciation by awarding you a *PURPLE STAR* I hope other Tek-Tips members will begin to notice the bottom-left-corner of a contributor's...
  20. DaleWatson123321

    Need EXCEL buttons designed to take cursor to various spot on sheet.

    Other options... 1) AutoFilter - useful if the users will be required to modify the data. 2) Advanced Filter - If the users will only be viewing the data, this can be used to extract data for each group to a separate sheet (at the click of a button - with VBA code attached of course). To...

Part and Inventory Search

Back
Top