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. Numbers1

    Eliminate a portion of the text in an Excel cell

    Wow!! This is too simple. Thanks to both of you for your suggestions. They both work. Thanks, Numbers
  2. Numbers1

    Eliminate a portion of the text in an Excel cell

    I downloaded an email list into Excel. The email addresses are numbered but the numbering and the email address are all in 1 cell....A1, A2, etc. There are over 2,000 email addresses and I am looking for VBA script that will take out the numbering in each cell. Info in each cell is as...
  3. Numbers1

    Selecting a range of rows from row 1 to row Variable

    Gavin: Thank you. That did the trick. I had browsed the site and always step through the code while watching the worksheet. The problem I have is I only do this once or twice a year and often forget. I appreciate everyone's help and patience on this forum. It's a great feeling when a...
  4. Numbers1

    Selecting a range of rows from row 1 to row Variable

    This doesn't work. I get: Runtime Error 1004 Application-defined or object-defined error. I always have a problem with the proper syntax. Thanks, Numbers
  5. Numbers1

    Selecting a range of rows from row 1 to row Variable

    ...' Record cell address intRowRef = ActiveWindow.RangeSelection.Row intColRef = ActiveWindow.RangeSelection.Column ****This line doesn't work!!! Rows.Range(1, intRowRef).Select Selection.Delete Shift:=xlUp End Sub Can someone help? Thanks, Numbers Thanks, Numbers
  6. Numbers1

    Using Excel on dual monitors

    Open one instance of Excel and 2 workbooks. Do not maximize the workbook window. Drag one workbook to the 2nd moniter and size it to fit that monitor. Do the same with the 1st workbook on the 1st monitor. Thanks, Numbers
  7. Numbers1

    Calculate number of days using 360 day basis

    Found the problem. I had defined the variable as currency. The 360 day method only accepts variables defined as doubles. Appreciate everyones' input and help. You guys are great. Numbers Thanks, Numbers
  8. Numbers1

    Problem Using the Find Method

    I just wrote the following sub and then call it when I want to search for something. Public Sub subFind(ByVal FindItem As String) ' Find an item loaded from outside procedure Cells.Find(what:=FindItem, After:=ActiveCell, lookat:=xlWhole, _ SearchOrder:=xlByColumns...
  9. Numbers1

    Calculate number of days using 360 day basis

    That doesn't work either. I tried entering the DateValue method as shown in the last response and any number of other combinations. Nothing passes the number of days out. The calculation is not happening. Any other ideas? Numbers Thanks, Numbers
  10. Numbers1

    Calculate number of days using 360 day basis

    No result! When I step through the macro the 2 dates populate but there is no result. dblNumberDays remains at a value of 0. Numbers. Thanks, Numbers
  11. Numbers1

    Calculate number of days using 360 day basis

    ...Below is the portion of code that does the actual calculation. I have not shown the DIM statements. The line that doesn't work is noted with *** ' Load data to perform calculation from present line Worksheets("Accr Int").Cells(intRow, intCouponCol).Select sngCoupon =...
  12. Numbers1

    Using Excel on dual monitors

    Open Excel twice. Place the first on monitor 1 and the second opened Excel on monitor 2. Then open files according to where you want to view the file. Thanks, Numbers
  13. Numbers1

    Calculate number of days using 360 day basis

    ...Below is the portion of code that does the actual calculation. I have not shown the DIM statements. The line that doesn't work is noted with *** ' Load data to perform calculation from present line Worksheets("Accr Int").Cells(intRow, intCouponCol).Select sngCoupon =...
  14. Numbers1

    Calculate number of days using 360 day basis

    Excel has a function Days360 which is used to calculate the number of days between 2 dates as if each month had 30 days. It appears VBA does not have that function. DateDiff uses a 365 day calendar. Does anyone know how to calculate on the basis of a 360 day calendar when finding the number...
  15. Numbers1

    Date calculation on 360 day basis

    PHV seems to be on the right track. Date1 and Date2 populate but no result occurs. I used the following: DayCount = Application.WorksheetFunction.Days360(Date1,Date2) What is missing to get a the resulting # of days?
  16. Numbers1

    Copy and paste depending on next field

    Use the Macro recorder to get an idea of what the code would look like for starters. It is in Tools, Macros, Record. While the recorder is on, go through your series of cut, copy, paste procedures and then stop the recorder and look at the code. You will have to do a little work to move to...
  17. Numbers1

    Date calculation on 360 day basis

    Excel has a function Days360 which is used to calculate the number of days between 2 dates as if each month had 30 days. It appears VBA does not have that function. DateDiff uses a 365 day calendar. Does anyone know how to calculate on the basis of a 360 day calendar when finding the number...
  18. Numbers1

    Return a calculated value from a Function Procedure

    Thank you all. Seems too easy, but try to find this is the help files!! Appreciate your input. Numbers
  19. Numbers1

    Return a calculated value from a Function Procedure

    ...as Integer Sub MainSub() intInteger = 2 Convert (intInteger) End Sub Function Convert(ByVal number as Integer) as Integer number = number * 4 End Function How do I get the 'number' (2*4) 8 back into the MainSub and put it in the original intInteger or another variable...
  20. Numbers1

    Variable in R1C1 formula pasted in Excel worksheet

    Thanks for the help. This works well. Numbers

Part and Inventory Search

Back
Top