Hi, This probably seems like an easy question but I don't know if it's possible to do or not. Let's say in cell A1 there is a drop down that let's you choose either A,B,C,D. In cell B1, you can either choose YES or NO. If you choose A in cell A1, then B1 should be have the value "YES"...

I have an excel form for users to fill-in. I need to prevent users from printing if specific cells are empty.

I have a user using Excel 2003. On a lot of excel documents, it is displaying blank cells even though there are simple data such as text or numbers in them. This doesn't happen with the column or row titles, but only with the actual row or column data. When in print preview, we can see the data in...

Hi, I have a macro that goes down through a column in a document and if a cell has the word "check" in it, it'll check the row of that cell and check it out. How I want to "check" it is to see if one of the cells in the row has certain text like "drive," "street...

Hello, I'm using MS Excel and have a series of subtotal in columns, I have hidden the numbers that sums up to the subtotal and now I want to copy just the subtotals to aanother spread. How can I copy the subtotal without the hidden details...both are in the same column

I have an excel docuemnt that i would like to merge some cells. However when i select the cells, right click and slect format cells the merge cells is grayed out and cannot be selected. I have tried double clicking where merge cells is grayed out and that doesnt' work either. The file was made on...

I'm using WinXP Pro, Duo core processor and MS Office XP. My Excel file recently performs very slow. Whenever I type any numbers and press enter to the next row, the status show 'Calculating cell xx%......' Is there any settings I need to do? Why does it have to wait for a few second only...

I have designed a form template that gets printed on a dot matrix printer to preprinted multi-part forms. I don't want to print the cells that are already pre-printed on the forms. How can I tell Excel not to print those specific cells?

I need two functions that will easily convert back and forth between the cells method and the standard 'A1' method: (1) rng1=wks.Cells(3,3) strRange=ConvertToAlpha(rng1) 'would return "C3" (2) strRange="C3" Call GetCells(lngRow, lngCol) 'would return 3,3

I was trying to get code that would select all populated cells to the right the selected cell and all rows below it that are populated. Basically i have the uppermost cell selected how do I select the rest of the populated range. All of the cells in the range are populated. Thanks