Search results for query: *

Hi, Try something like =IF(A5<>100,IF(A5>100,"Pass","Fail"),"Draw") Nested IF's work well to obtain multiple outcomes.

Yes, I suppose so, but the range referenced always contains information (what I found to be a common question to a similar problem). Could this still be the reason?

Greetings, I have come across a strange occurrence that I can't source: With a certain workbook I have open, closing Excel completely using the upper-most and right close button (x) gives the following message: "A formula in this worksheet contains one or more invalid references. Verify that...

Sorry for the delayed response! Tony: Not getting an error - with the 1-d array, the range=array code displays only the first value in the array in all cells. I did get the 2-d array to work as hoped, so thank you PHV, and (the rest) for you thoughts on this.

Could you elaborate on this a bit more? I don't understand how that is supposed to work. Thanks again!

Hello I currently have an one-dimensional array (distinctCusts) filled with strings. I am printing the values of the array onto a worksheet by looping through a "for" loop as follows: With Range("X6") For iCust = 1 To nDistinctCusts .Offset(iCust, 0) = distinctCusts(iCust) Next End...

Hello, I am trying to change the value in a cell only if the worksheet is protected, but I can't seem to find the correct syntax. The code is as follows If [Worksheet g is not protected] Then g.Cells(1, 3).Value = 1 End If I don't want excel to attempt to write the value in the locked...

Thanks all for the feedback!

I am using the following code in a macro to simply write data to an array and then output the results to a worksheet. Sub test() Dim Arr(0 To 5) As Double, row As Integer Dim i As Double row = 1 For i = 0 To 5 Step 0.5 Arr(i) = i Next i For i = 0 To 5 Step 0.5 Cells(row, 1).Value = Arr(i)...

Thanks you guys, sorry for the late reply. This is awesome. The last bit of code from Zack is just what I needed. Thank you very much for the extensive time you have both put in. Enjoy the stars. Matt

Thanks for the reply. I am not able to get this to do anything for some reason. Does the macro run automatically? Also, it appears that the code places the VLOOKUP formula in column B when the user deletes what is in column A. I need it to do just the opposite: Use the formula when A is NOT...

I know my question was a bit vague. . .sorry. VLOOKUP is in column B cells. Cells in column A are actually populated by a drop down list in each cell using data validation. The user can either pick a value from the list or leave blank. Goal: If cell in column A is blank, the user can input...

Greetings, I have a spreadsheet with a cells in a column (say column B) that use a VLOOKUP formula to return a value that depends on what the corresponding cell in column A says. Is there some way to say that IF(A#="",take user input,use VLOOKUP formula)? I have tried doing this using data...

Thanks for your help. That was just what I needed!!

Hi there, I have a macro that basically moves a bunch of cell ranges around, prints the worksheets, and moves the cells back to their original locations. A sample: Range("Q85:W107").Select Selection.Cut Destination:=Range("A225:G247") Range("Y85:AE107").Select Selection.Cut...

This worked, but my question has become more complex. I have a macro that saves my active workbook, which is a template file, to a specified directory with a different filename. Is it possible to make it so that the saved file then has no macros with it (maybe the modules are deleted in this...

I have a workbook which has no macros associated with it, but every time I open it, the warning about macros and enabling/disabling them appears. Is there a way to fix this. Thanks.

Thanks Skip, I found what I needed. Thanks for pointing me in the right direction.

My objective is to have two combo boxes, with the second box populating depending on what is selected in the first box. Currently this is performed by the following: 1. The first box populates from a list (A2:A17)and outputs the number of the selection to cell A20. 2. Cell B20 uses...

Hi, I am feeling much better thanks to you guys; thank you for the replies. TonyJollans, your suggestion worked wonders, and I was able to simplify things even farther. That was one thing I had never thought of before. Its nice starting out a day learning something new. Thanks again! Matt