Search results for query: *

That is correct. If cell#2 contains 0 I want to fill cell#3 with "N/A". There is no code involved with the vlookup, but I'm tring to create an sheet_change code to put N/A when cell#2 is 0.

I have vlookup to look up the specifications of the part, in the test area, I just want Not applicable to show up if there are no washers. If I have a vlookup there, it will be erased when the QA people key in test results.

Thanks that works, but now i get a new error. application-defined or object-defined error. Here is part of the code. Dim total As String Dim m As String Dim n As String Dim v As String Dim y As Integer 'Build Daily Sheet total = WorksheetFunction.Sum(Range("R2:AB2")) 'Get data From...

I need to add a few columns together and it is not working. Total=Sum("R2:AB2") What am I doing wrong? I did a recorder to get this initial forumla, but it is not adding the columns together.

I have a report that Qualitity people fill out after testing part numbers (bolts). The program looks up the part number and does a vlookup to bring over specifications for the part number. Some part numbers do not have washer and when the specifications for washer come up 0, I want where the...

I changed it to a changesheet event. It still does not work. Could you take a look and see what I must have missed. Private Sub Worksheet_Change(ByVal cell As Range) Dim reportlocation As String Dim sh As String Dim strvar As String Dim p As Integer Dim m As String strvar = "N/A" sh = "1244...

I'm trying to get this macro to run when the workbook is opened and keep running the whole time. I get no error, but the macro is not running in the background. Can anyone see why this is not working? Sub Input_NA() With ActiveWorkbook .RunAutoMacros xlAutoActivate End With Dim cell As...

I have it on the share drive and it still is giving me an error. Method "AutoUpdateFrequency" of object"_workbook" failed. Here is the code I'm using Private Sub Workbook_Open() ActiveWorkbook.RunAutoMacros xlAutoActivate ActiveWorkbook.AutoUpdateFrequency = 5...

I did use the recorder and made changes to fit the program, but that did not work. Here is the code you requested. Sub Bolt15N() Dim cellstart As Integer Dim n As String Dim testrange As String Dim sh As String Dim destsh As String Dim p As Integer Dim m As String Dim testrange2 As Range Dim...

new error. It gives me a syntex error on that line.

I put the workbook name in quotes and the period back in and now I'm back to getting expected: identifier or bracketed expression again and it still highlights the first backet on ("sheet1"). I've tried looking it up (vlookup for workbooks) in google to try and fix this error, but I have no...

Will try that.

I took out the . between (Hardness_conversion) and ("Sheets1"), now I get a syntax error. when running debug, hardness_conversion is empty. It is not pulling the data from sheet1 for the vlookup. Any suggestions on why this is happening.

When I key in the changes, I get an expected: identifier or bracketed expression. The error highlights the bracket in front of ("Sheet1"). Any suggestions on why. =Application.WorksheetFunction.Vlookup(myrange.Value,workbooks(Hardness conversion).("sheet1").Range("A2:D50"), 1, False)

Thanks for the tips, I will give them a try.

My range are in seperate rows A 38 39 40 41 42 So I have soemthing like this I vlookup the answer standard = sheets(destsh).range(bolt(1)) if answer > bolt(1) + 2 or answer< bolt(1) -2 then

I have writen the following code to do a vlookup into a different workbook. I get an compile error - syntax error, any suggestions why. =Application.WorksheetFunction.Vlookup(myrange,workbook[Hardness conversion]!("sheet1").Range("D2:D50"), 1, False)

That looks like what I'm shooting for, I was just not sure if that would work. Thanks for the suggestion and I will let you know if it works.

Is it possible to write code where a forumla or if statement looks at +/- a number. Say I run a test that gives me 44 for an answer. I need this to check the standards and if it is more or less then 2 of the standard, I will need an error message. Standard range is 36 and 40, need to look...

There is no protection on the workbook or worksheet and I tried to share the workbook, but share workbook under tools is greyed out.