Search results for query: *

I would like to write a macro that would read in only the first couple lines of a very large text file. Basically I want to read the first few lines to determine if the file meets specific criteria before deciding if the entire file will be opened. I can specify the StartRow for reading data...

I'm having an issue with tabbing between fields on a form that I've built in Excel. It works fine on my PC, but when a co-worker opens the spreadsheet and tries to tab between fields on her PC it instead inserts an actual tab character. Here's what happens: If she uses her mouse to select a...

I have an Excel spreadsheet that will be used by 2 users. It has a form that they populate with information required to perform a calculation and they can save their inputs if they choose. Currently there is a sheet in the file where their inputs are saved. The data on this sheet is also used...

I have designed a UserForm that gathers over 40 pieces of information required to perform an annuity calculation. The data includes dates, dollar amounts, percentages, other numeric data (such as the term in years), and text information (such as name). I have 2 questions: 1. Is there an easy...

I have designed a UserForm that gathers over 40 pieces of information required to perform an annuity calculation. The data includes dates, dollar amounts, percentages, other numeric data (such as the term in years), and text information (such as name). I have 2 questions: 1. Is there an easy...

I have created a userform and would like to have a list of the objects that I have placed on the form (labels, textboxes, etc.). I have used 3-character prefixes to differentiate between the different types of objects, but it would be useful to see an alphabetic list of them all. Basically...

I am using Excel 2003 and have followed the steps on the Microsoft website at http://office.microsoft.com/en-us/excel/HP052022151033.aspx to populate a drop-down box with a list of values from another workbook, but I get an error message that says "You may not use references to other worksheets...

This is more of an annoyance than a problem, but I'd appreciate it if anyone has a fix. The other day I selected File Open from the menu in Excel and hit the maximize button so that I now see a full screen. Now I can't get it to shrink back down - there is no "-" symbol in the top right hand...

I am having trouble printing an Excel report that has multiple pages with the same layout on each page. The report is numeric data with borders around certain cells. When I have the graphics mode set as vector, the right hand borders print fine on page 1, but are shifted slightly left on all...

I want to be able to build an "average" formula where I am calculating the value of the beginning and ending row to use in the formula. For example, if the formula I want is =AVERAGE(A2:A7) I want to be able to build the formula and calculate the values 2 and 7. If there was a formula in cell...

Yesterday I'd asked about retaining the formatting on the X-axis when exporting a worksheet with a chart to a new workbook. I got excellent advice to de-select the "Linked to source" box on the number tab of the Format Axis properties. I have another chart that I also want to export that has...

When I copy a worksheet with a chart to a new workbook the formatting of the x-axis is lost. In the source workbook the format is a date formatted as Oct-07, but when I create a copy the date becomes 39356 which is the numeric value for Oct. 1, 2007. Is there any way to retain the formatting...