Option Explicit Sub SASLineEmUP() Dim lr As Long Dim i As Long Dim lc As Long Application.ScreenUpdating = False Columns(1).Clear lr = Cells.Find("*",...

The navigation buttons in Excel 2007 do not seem to work the way they did in Excel 2003. I have tried them on multiple computers. I know about right-clicking...

I accidentally hit Ctrl S and saved a document. Unfortunately, I meant to do a Save As, instead. Is there anyway to recover my original document? I haven't...

See subject question........

I have cerated a macro button in a spreadsheet, and I would like to know if it is possible to save that button onto a toollbar so that I can use it on any...

In ColumnG I have the following formula array from row2 all the way down to row100 =IF(ROW(FilteredMonday)-ROW(E2)+1COUNT(F2:F100),"",...

I would like to find the second occurence of a specific alphanumeric character in a cell. For example, if cell A1 contains "BOBBY" what would be the formula...

I have custom macros that are saved in an .xls file under the XLStart/ folder in Excel 2003. These macros are referenced by an Excel11.xlb file that holds...

Hi, I have two coloums. One has text and the other has Values. I need excel to search through a whole coloum, and summerize the results. My coloums look like...

I have information in column A of a task sheet. The information goes from row 1 thru 35. Column B is where I place a "x" to say the task need to be...

Does anyone have any suggestions on how to determine the value within lists? For example, There is a given date in cell A1, 06-Jun without concerning year, I...

I have a report that contains a number of columns - and where the report contains a number of lines for a range of 'cost centres'. The report has the cost...

Hi, I'm required to present some info at my work, using two excel files. This is the task: File 1, has ID numbers in column A, and column B is blank. File...

HI I need to express something in VBA , and am having trouble with it. I need to say this : IF E1 CONTAINS "1bx" OR "2bx" OR "3bx" AND J1 =11 THEN PUT 1 ,...

For some reason none of hte formula in a spreadsheet are working. The spreadsheet is on a netowrk and when others open it, the formulas work. When I open...

My bank only lets me download my account data to an excel file. Does any one know if the xls file can be converted to an ofx (Money 2007) file?

I need to create a variance formula for the data selected in a pivot table. My problem is that the data is coming in from one column and I don't know how to...

Hi, anyone who know the solution below ? Start Date End Date 01.01.10~31.12.10 01.01,11~31.12.11 1)01/10/09 31/01/10 ...

I have a spreadsheet which contains 3375 records (Excel 2007). My quandry is the following: I need to reformat the rows into columns for each Dealer...

I have installed Excell 2010 and now when I open the program, it opening all the excels files. It also is trying to open the other files like .doc in that...