I can't remove page breaks in a couple of my excel files from certain computers. When I open a file in computer A, I don't see any page breaks. But when I open it in computer B, I see the page...
Hi,
I need bitwise and operator in my worksheets,
To compare integer values with a pattern of pure 2^n values
I wrote a little vba function that does the trick
Public Function BITAND(a...
I have two sheets Sheet1 and Sheet2, I want to copy d12:d37 on Sheet1 to Sheet2 column D12:d37. Before I copy the data I need to insert a new column D which moves over the old column D to C...
What is the correct syntex to return the maximum numeric value in a list using VBA code? I have a spreadsheet with a single column list and would like to find the max value.
I've run into this in the past and don't remember how I got around it. I have an inherited spreadsheet. When I type a formula in the cell it just sits there as a formula . . . it doesn't sho...
Excel
Hello,
How do I convert a date column in this format dd/mm/yyyy to this format yyyy-mm-dd? A macro perhaps?
I don't want to change the display format only, but the underlying va...
I need a VBA control that will let uses select multiple choices from a drop down menu as well as enter their own free text. This control must exist in a cell for multiple range of cells (i.e....
When I save a .xls file as .csv file, double quotes are added to 2 fields, like this one:
"<meta name=""description"" content=""Buy . .
but should be:
<meta name="description" conte...
I am trying to upload data into a data analysis program (Spatial Analysis for Distance Indices, aka SADIE) that I recently downloaded. I have data in Excel, but I apparently need to convert it...
I get the follwoing error when trying to open a .wk1 file in excel 2003 You are attempting to open a file type that is blocked by your registry policy settings.
We have wk1 files all over ...
i have 3 buttons the build 3 different layers of 'protection' in an excel 2007 workbook, and one that completely locks the workbook. the code is working (just using xlVeryHidden and worksheet ...
Hi,
I am wondering if anyone can provide me with the correct code do to the following task:
I have 5 workbooks. Each workbook has one worksheet that contains a table of data. I want to do ...
I was trying to get code that would select all populated cells to the right the selected cell and all rows below it that are populated. Basically i have the uppermost cell selected how do I s...
Hi Everyone-
I have gotten help on step 1 of the process below. I need help with steps 2, 3, and 4 which are excel based. Attached is the code I have been given so far. I am stuck with g...
I have one user who is having slowness when opening excel files both from the network and locally.
The users computer is as follows Latitude D620 dual processors at 1.8ghz, 1gb ram, Windows...
Hello
How to stop Excel 2007 .creating backup files .xlk files
I have the following data:
Emp 1 1 5
Emp 2 5 3
Emp 3 9 14
Emp 4 13 12
Emp 5 14 3
Emp 6 3 9
Emp 7 7 10
Emp 8 12 6
Emp 9 11 9
Emp 10 7 13
What I want to be able to do is chart the...
Dear experts,
below is my excel table
column A
1 BRAM
2 JOHN
3 BRAM
4 JOHN
5 RAY
what is the formula to retrieve the distinct rows of the table above so the result will be ...
Trying to copy all the chats from excel sheet and paste it to a word doc
I have about 40 charts on excel sheet and I want to paste 2 chart on each page how do I move to the next page
and ho...
How do I delete a named range
I have information about a set of issues affecting a business captured in an Excel sheet. Each issue is assigned a priority rating (Extreme, High, Medium, Low).
To present the information,...
I have a spreadsheet that uses the Excel Solver-Add-In for linear/non-linear programming. My sample spreadsheet is stored at the following EE URL: http://www.ee-stuff.com/Expert/Upload/get...
I have a users with Excel 2003 SP3 and one particular file is a problem. When she double clicks on the file from her desktop, Excel opens, but shows the grey screen. The odd part is, it show...
I have a worksheet where I need to firstly autofit the column widths of the data (excluding the first row which is a header) but limit the maximum width of the auto fit to 25. Then in specifie...
I have a chart which shows a status at a particular time with the time given in cell A1. Every time I change the value in cell A1 I get a new chart for that time. I am trying to animate this b...
