Recent content by westma

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...