Recent content by techie99

Not sure about that. I would really like to work with what I got. Any other ideas?

I have a named range on a sheet that is used to populate a data validation drop-down box. In my range I have blank cells so the user can easily add something to data validation drop-down without having to worry about increasing the size of the range so that data validation picks it up. The...

Skip,thanks for your concern. I needed to know this for a if then block of code. So, this will only happen under certain circumstances. Thanks anotherhiggins for your post. I just had to change it slightly to target.clearcontents, otherwise it would clear the formatting on the cell, when I...

When a user enters a value into a cell and hits enter, the activecell is no longer the cell that the user entered a value into. My question is, how can I delete the contents of the cell that the user just entered data into? Thanks.

Thanks for the suggestions, I'll give them a try.

I need an Excel formula that adds up specific cells in column H that meet the following conditions. If the cell in column D = 100 or 800 AND if the cell in column G does not equal "CA", "FML", "FMU" or "ULW". A B C D E F G H I J K 100 CA 2...

But if I hide them, it'll hide them on the left-hand side too, won't it? Basically I want the user to see every column on the spreadsheet, but only see it once. I don't want them to see the same column again when scrolling on the right-hand side of the screen...

Basically on the split on the right-hand side of the screen I don't want them to see the first 6 columns whatsoever.

Skip (or anyone else who has the answer) I just had a thought...I can do a split instead of a freeze pane, however, I would like a way to prevent the user from scrolling to the first 6 columns on the right-hand split (to eliminate confusion, the people the spreadsheet is intended for don't use...

Thanks Skip, I'll give it a whirl.

Can data validation be performed within this combo box? Before I had an input message appear when the cell was clicked and an error message that appeared if they tried to enter something not listed in the combo box...

My organization has Excel 97 (Yeah, I know, the stone age!) I've encountered a documented bug in Excel 97 whereby if you freeze panes on a section of the worksheet that has data validation drop-down boxes, they stop working. Is there any programmatic workaround to get around this problem, like...

Where does body{} go? I'm actually using tables because I was trying to avoid CSS because of problems with it rendering properly in Netscape.

I would like to know how you align a table to the very top of the screen. I don't want to see any space between the top edge of the screen and the table and it seems that Internet Explorer, by default, is doing that.

Anybody?