trying to make an if stmt that takes codes I have entered in a column and gives them values
Any help would be appreciated!!

When I write in a Cell in Excel if I am writing integer then Cell takes that
Value but if I write a string value then I cannot see anything in Excel
File.
       _objRange = _objWorkSheet.Range(_objWorkSheet.Cells(_intCurrentRow,

Trying to highlight lowest cell in columns...if 2 cells in same column
contain same low number I dont want any highlighted.Not sure
how to set up formatting statement in conditional formatting.
Any help out there?  File example is attache

I have a spreadsheet that I don't want people to be able to accidentally type or erase contents of a cell with a formula.  If I protect the sheet and then go back and un-protect the cells that they can type in....that works for the cells with the formulas, but then the cells they ...

How do I go about combining the test of several column.  This is what
need.  I have a very long excel file.  Within this file, I need o
search for the word "menu".  Once the word is located, I need to b
able to take the word within this cell and then combine it with th

I am trying to get a count of where item in column D begins with a 2
and the item in column F begins ma
Excel doesn't like the wild cards... all the numbers in column D begin
with a 2 (no exceptions) but are all different. Not everything in

I have 13 WS with same layout, is there anyway I can use grouping to select
all 13 WS, then select a cell range and apply a named range to these cells
across every WS?
Basically while im setting up this WB any changes I make to one of these 13

hi i am currently building an accounting program for use in excel but i
havent a clue how to sort out the data, as regards eporting quarterly or
monthly reports, and individual category reporting eg fuel costs, rent
rates etc

I'm trying to automate the creation of a vendor report.  Basically
need a formula that, based on a unique vendor number, will:
- check column B to see if there is a buyer number (which means tha
the item is sold)

I have an array with hourly data for an entire year.  Normally I use
CountIf on this array to ascertain how many occurences occur ove
certain data ranges over the entire year.  So assuming the data is i
B1:B8760.  I would Count the number of occurences for the whole yea

Is there a way to choose one cell in each sheet of a workbook then type
the date in the first cell and make all the other sheets increase by one
day through the workbook?  Ex.  April 19,2004 on first sheet and April
30,2004 on the last sheet with each sheet in between being the ...

I would appreciate some good site links for XL how to's and working examples
aimed at Novice - Intermediate.
Many thanks,
Steve

Anyone help with this one?
Try to remove empty rows from a spreadsheet.
Hend
--

Admin please delete my first 2 posts....Dont know what happened!!!!
Hi Could anyone please help me????
I would like excel to work out and  print the permutations of 10 thing
taken 4 times at a time.

Dilema
I have a problem in date formate.
I want to put the date as "day-month-year"
but in excel some cells behave differently like "day/month/year"