/ Hi, If I have worksheet where I want to delete all the rows that have (say) 0 in column C is there an automatic / formula way to do it. I've tried filter and...

Hi, I need to have a macro such that it'll select all sheets from the first to the sheet before a sheet called "test". After selecting these sheets, i want to...

Is it possible to copy a value in a cell and add it as a comment? How would such a macro look like? Preferably the comment box should be resized to just reveal...

I am looking for a "counting" formula that will count cells in a range based on their color, so that if I color a series of dates (to show 'vacation) the...

I would like to use the "reversed-out" text. However when I change my background color to blue "example" and I print, the background will print dark or in...

I have recently upgraded from Office 2000 to office 2003. I have Excel worksheets containing VBA macros which maps create maps from the data. These worked fine...

I have a workbook that is used by multiple people. There are 5 cells where times are entered. There seems to be a problem that people can't enter the right...

I try to use the following CountPosS = WorksheetFunction.CountIf(TradesDiff, "0") and I get an error messege type mismatch when I run CountPosS =...

Hi, I'm currently working on an application that can export data in "CSV" format, and then launches Excel to view the CSV data. This works perfectly ok for...

Hi there Wondering if someone has a macro which scans through all cells in all worksheets and if it finds a cell which has the same value of one of the sheet...

I am experiencing the problem described in Knowledge Base Article 316399 - No RETURN() or HALT()function found on macro sheet. The resolution is to obtain the...

i work at a tow company and have to calculate dates and charges a lot of times.i wiould like to have excel do it in a spread sheet.for instance date in ...

Hi Excel Forum, original ThreadID: (http://www.excelforum.com//showthre...threadid=239331) I have tried a Pivot Table as was previously suggested but the...

I am looking for a formula that will add cells based on condition. Ex. If i have ten cells with different values (130, 131, 143, 142, 144,130,...

The whole column A begin with SP, and I wont to add different numbers on each row after the SP. how do I do that with out I should have to go in to each...

in cell a1 john in cell b1 smith, i want to have in cell c1 both names how do i make it? --- Message posted from http://www.ExcelForum.com/

Why are the following lines of code not highlighted (in red) to indicate a syntax error when they are clearly...

Can you put more than one validation in a cell? Here are my column headings: Arrived Triaged Registraion To ED Saw MD Discharged I want a...

in A1 it says John 1n B1 it says Smith, how can i poot both wards in c1 with a space --- Message posted from http://www.ExcelForum.com/

When I double click any Excel Workbook Icon, only Excel opens. The workbook is not loaded. The only way I can open up workbooks is though the File - Open...