I am running into significant performance bottlenecks running large-scale simulations on Excel 2003. Any suggestions? I am running a P4 laptop 2.4 GHz with...

Hello, In MS Word, you can go to Tools-Options-General tab, and change "Measurement Units" to have all measurements work with inches, centimeters, pixels,...

after reading many posts, there might be a better way to do what I am trying to accomplish. I have 2 workbooks, db.xls used for storing info such as customer...

Hi, I have a speadsheet with a userform into which items being ordered are entered. Clicking OK launches another form with pricing info displayed thanks...

I have to get data into columns. the data is in rows for example cell B1 (W436), cell B2 (X32), cell B3 (Y4639890), cell B4 (Z58911) cell C1 (X453), cell C2 ...

Frank Kabel wrote: Hi are your Excel columns real date values (just formated as 'MMM-YY')? -- Regards Frank Kabel Frankfurt, Germany Yes, the...

HI!! I tried to create a search macro by doing the following steps. 1) Clicked on an empty cell 2) Clicked on record macro 3) EDIT FIND typed the copied...

I've created several spreadsheets for collectors of a certain movie directors. While all of the content is complete, I'm looking for ways that i might improve...

At this time, I cannot use VBA. Here is my objective: For a given treasury note security: Cell A1, Date 6/17/2004 - today's date Cell A2, Date 7/15/1997 -...

Hi, I was given a report in which the each cell in the first column is set up as Last Name, First Name. I need to split it so that Last name is in column A,...

Hi! I have a problem that I hope someone will be able to help me with. I have an Access table that I exported to Excel. Some of the data has linfeeds in...

I’m trying to add 31 more columns to the end of my spreadsheet and I keep getting this strange error message: “To prevent possible loss of data. MS Excel...

Is there a way to lock only the cell format? I want to be able to copy and paste data from one cell to another without changing the cell formating. I would...

I am currently using this excel form to fill in my auction information in order to get it bulk listed. The fields given for the first row image url is as...

I don't know what it would be called or if this can even be done, but I need one entry in a spreadsheet to always be in row 26. The way I've gotten around...

I posted this to the Excel forum on UtterAccess already since I happened to already be there, forgive the "crossposting". I'm wondering if anyone knows how to...

when i open an excel workbook, i have ThisWorkbook Module opening another workbook. Is there a vba code i can use in Thisworkbook Module to hide the...

Rather than selecting the "Automatic Size" for each cell comment ONE AT A TIME, is it possible to set your options so that all cell comments start out with the...

Hi, I have got an excel spreadsheet which has 500+ hyperlinks. I need to extract the address behind the text to be able to import the actual address into a...

Having problem protecting cells in shared folder on shared drive. Need to protect a group of cells that are for viewing only, but leave adjacent cells...