General

Insert row disappeared
Normally, when I work with a list, an "insert row' is displayed directly below the last row of data, with a blue asterisk (*) inside the left-most cell. Now, when I reactiveate the list (by clicking a cell within it), the list border does not drop down to display the inserted row anymore. How did I lost t... 26 Oct 2009 14:27

Filtered data range reference is too complex
Hi Shane, You mentioned that there's a limit to the number of discontinuous selections that Excel can handle, do you know what the number is? I have 65K rows and want to know the limitation so I know how many times I have to repeat the steps of copying discontinous selections. Thanks, Bagia "Shane Deve... 21 Oct 2009 02:44

How do I stop Excel from selecting more than one cell when clicked
Everytime I choose one cell it selects a block of cells and I don't know why. ... 20 Oct 2009 16:46

Excel 2007, Page Break Preview - something wierd
In PB Preview, I try to drag the page break to the edge of the print area & immediately have page breaks around each cell. I've tried clearing & resetting the print area, resetting the page breaks, clearing the page breaks, making sure the drag & drop function is enabled, removed the "excel.exe" file from the C... 16 Oct 2009 20:44

Excel 2007 is stuck in Document recovery mode
I am unable to clear the Document recovery pane. Power went out, it tried recovering the file and now it is stuck and always thinks the same file needs to be recovered. No option to delete as it is grayed out. File has been saved several times. I cannot find any reference to this nor figure where you keep the... 15 Oct 2009 12:46

VBA to merge cells
The format that another application spits out is one that I would like to make user friendly. Here is an example of what I am looking at: WELL: 5122110000 3096971.9998 PICK: GRETA **Each line of data is in one cell In my normal file I have anywhere between 400 to 2000 rows of data. I would like someth... 15 Oct 2009 12:46

VBA macro for reading text file into Excel
Hi, I have text file created by an application. I need to read that into excel. The structure of the text file is as follows: (a) Several lines of text of equal length, with blank lines interspersed. (b)A text line with headers identifying the data in that follows (c)Several lines of data. This data in each line i... 14 Oct 2009 13:41

form that retrieves existing data from table and allows editin
Hello again, I found http://contextures.com/xlUserForm01.html whose logic and steps are the first part of my required form. After reading this, my question is 1. how do I retrieve previously entered data into this form structure for editing? 2. program validity checks, ranges into the form? John... 9 Oct 2009 13:46

Help Needed: Pivot Expand/Collapse Buttons Not Showing For 2 Cubes
I very much need an answer to my post on 9/30. We have Excel guys pointing fingers at cube guys and cube guys pointing fingers at Excel guys. All of our cubes produce the expand/collapse buttons for all dimensions when pulled into an Excel pivot, except 2 cubes don't. Need to know why? Is it an Excel se... 2 Oct 2009 13:12

How do I remove redundant rows at end of sheet?
I'm cutting a larger Excel file into 2 smaller ones, and then converting to csv. The original but now smaller file shows empty lines when converted, which causes a problem for the resultant application. Rather than cut and paste this into a new Excel file, can anyone tell me how to resolve these empty, but app... 1 Oct 2009 09:28