Search results for query: *

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

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

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

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

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

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

Is it possible to place a variable, that is defined in a module, into a formula that is pasted into a cell on a worksheet? Dim intColRef as Interger intColRef = 5 ActiveCell.Offset(0, 6).Range("A1").Select ActiveCell.FormulaR1C1 = "=RC[5]" Instead...

I would like to take the focus off of a selection after choosing it in a drop down combo box. The combo box is bound to an Excel worksheet where it obtains the list of items to be displayed. After selecting an item from the list, it is in blue and can be edited. I would like to have the...

I have created an Excel file in my application that I want to automatically copy to a floppy disk in the A drive. I have a message box (vbOK) come up instructing the user to insert a disk in the A drive but do not know how to check to see if it has been inserted before proceding with the copy...

I want a procedure that loads a calling array with the data contained in predefined row and column references of the active spreadsheet. I have gotten this far with the code shown below. When run, the procedure loads the data but does not pass it back to the calling array. What is missing...

I have created the following procedure which loads an array using Sub LoadArray. Dim aryFunds () as Variant Dim intCountRow as Integer Dim intCountCol as Integer Dim strCellContents as String aryFunds (ArrayName) Private Sub LoadArray (ByRef ArrayName as Variant) For intCountRow = 1 To 5...

I would like to maximize a user form that I have created for a project that I am developing. There does not appear to be a way to do this in either the properties window or in the upper right corner of the user form. The help instructions refer to minimize, maximize and close but provide no...

I want to replace specific row references in the Rows Method with variables and can not figure out the format. The format as shown in help is: Rows("10:11").Select This code selects the 10th and 11th rows specifically. I tried using variables instead of the row references as...