I've password protected my worksheets, I know there's a way to protect my VBA code as well, but I can't remember how to do it? Could somebody refresh my...

Onhimesa wrote: Raw Data Column1 = Reason , contains values 1,2,3,4,5,6,7 Column16 = Shift , contains values 1,2,3 Column 15 = Hours , contains...

If I have a cell that contains the following "John Smith" what function can use to split this into two cells, one with "John", the other with "Smith"?? Thanks!

Joe Gieder" wrote in message ... I use the Match Function to determine values within ...

Is there any way of showing a ratio in a cell in the format "4:1" or "5:2" for example when dividing one number by another, rather than the answer simply...

Hi- Is there a way to erase the contents of a cell without erasing its formula? Thanks

Spreadsheet files I have created on a read/write CD are recognized by Excel as read-only files. Excel will not allow me to save changes to these files. The CD...

How do I copy from one worksheet to others.

I would like to password protect a worksheet. I think I have the settings correct, but anyone can copy and paste the range of cells and paste to another...

I am using the concatenate function and want a dash "-" between each entry and no if the cell is empty, no dash. Example: =CONCATENATE(A1,B1,C1,D1,E1) I...

I am entering both pre and post-1900 dates and need to sort by date. Pre-1900 dates are entered as text. The normal sort function sorts dates and then...

I need help with a listbox. I have figured out how to add a listbox to a worksheet from the Forms toolbar and how to specify the input range. I want to be...

I posted a message to this effect to the programming NG and never saw it. That's one problem. The original post was asking why 9 out of 10 posts that I click...

Can someone help me understand the error in my logic for filtering a list of times with a formula (IF statement used to select a RANGE). It apears only to...

I am trying to change text from all caps to lowercase or like you can in word. Not finding it. Does it have to be a formula and if so..please give details.

Is it possible to format an entire column with check boxes without having to add a check box for each row being used?

I desperately need to be able to test for the existence of bold formatting of a cell... Need to do this with an IF statement: =if( CELL_IS_BOLD, true,...

To speed up a macro that renames and sorts worksheets, I used the application.screenupdating=false function. VBA ignores the function though (verified through...

Hi: Been trying with no joy: LOOKUP(VALUE(MID(C4,2,1)),$J$3:$M$10,$K$3:$K$10) Cell C4 is formatted as text and equal to "123" Am trying in the above example to...

Hi Debra, I am running Excel 2002 and have created the GETPIVOTDATA function by selecting the cell in the pivot table. All works well for me. Problem is...