ActiveCell.Offset(x).Activate Offset works great when I put a value in for "x", but how do I make it look up the value in a worksheet cell "a1" and use that...

Using Microsoft Works Spreadsheet or Microsoft Excel I have had multiplication values be wrong. 6x.08=.46????? This problem has been on two different...

Hello Again I know I've done this before but but be having a brain fart. I need to copy my spreadsheet to a sheet in the same book but when I do it does'nt...

Excel will not allow 1 million rows...it's limit is 65535 -- Michael J. Malinsky "sue" wrote in...

Hi all. I need help with a formula. I want to roundup if a value's decimal is greater than .7 and rounddown if less. How do I get the value of the decimal?

Can somebody tell me how to look up a list of items in a column from an array and then return the information in a cell that is in a column which is the same...

How long is Microsoft gonna have that Office Preview logo on the top of this website page??????? The Office has been out a month now, not no preview no more.

Good day to all, I have a file wherein all the list of hotel equipment files are listed ex. col. A B HVAC-Apartment HVAC...

Hello

Is there a way to shade every other line in my spreadsheet without going line by line? Stephanie

hi. could someone show me how the code looks to use this function to open up these 2 files: c/:File1.xls c/:File2.xls thank you

I am trying to learn how this instruction works. Could you show me how the code looks to execute this command on these 3 files... c:\1.xls,c:\2.xls,c:\3.xls...

With the low values and scores arranged like this in E12:F15 and your value "52" in H14 0 D 25 C 50 B 75 A =VLOOKUP(H14,E12:F15,2)

For #1- there is argument over the best way to do it, since you want to be aware of errors in your data. But this is what I would use...

I have a complex workbook I'm developing where I have lists of States, Contracts and Endorsements. I've created a drop-down that will select the State. Now I...

I'd like to take product info from the excel worksheet database and link it to individual spec sheets. Basically, I want to be able to input this info once...

Is there a way to make an IF statement based on whether or not a cell has something/anything in it? If A1:A2000 have "something in them"...

Help! I'm using the XIRR function for a series of cashflows. It appears that instead of calculating IRR back to the earliest cash flow date, it is...

Hello. How do I round up to the nearest quarter decimal place? i.e. The value 5.71 should be 5.75 and 5.76 should be 6.0.

I think it would be easier for you to use conditional formatting. Select the cell (or range) you want to format. Go to FormatConditional Formatting Select...