Search results for query: *

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

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

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

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

In an Excel Macro I can not figure out how to write the code to identify the range of rows 1 through a preloaded variable row number. Here is what I have so far: Sub Test_data_format() Dim intRowRef As Integer ' row reference of a cell Dim intColRef As Integer ' column reference...

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

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

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

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

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

Excel has a formula function Days360 which is used to calculate the number of days between 2 dates as if each month had 30 days. It appears this is not available when writing a Macro in Excel. DateDiff uses a 365 day calendar. I am writing a macro in Excel to calculate the accrued interest...

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

I am writing a macro in Excel to calculate the accrued interest on a list of bonds since their last interest payment. I want to be able to insert a new date to accrue to and the macro will calculate each time that I change the date. Some bonds are calculated on a 365 day basis and others on a...

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

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?

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

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

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

Novice at VBA so bear with me. Am trying to convert the number in a variable to another number and have to do this quite often so wrote a Function to do the calculation and return the result to the same variable. Dim intInteger as Integer Sub MainSub() intInteger = 2 Convert (intInteger)...

Thanks for the help. This works well. Numbers