Search results for query: *

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'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 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)

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

The error I'm getting is Method 'AutoUpdateFrequency' of object '_Workbook' failed. I have the ThisWindow page set up as workbook and Open, like described in the help file. Any suggestions on why it is failing. Private Sub Workbook_Open() ActiveWorkbook.RunAutoMacros xlAutoActivate...

I need this to go through all if statements before it loops. The macro look at the one if statement and goes to the end and loops. I need the macro to do mutliple if statements first then increment and loop. Any suggestions on how to do this. 'Output into destination sheet...

Here is a code that I created and I need it to run through the entire code before it loops. I need the code to look at all the ID numbers before it increments and loops. Any suggestions? Sub copyinfo_to_main_page() ' ' copyinfo Macro ' Macro recorded 4/7/2006 by Wendy Smith ' Dim Cellstart As...

Here is the code I wrote and the auto run is not working. Any suggestions on what I'm over looking. Sub Macro12() ' ' Macro12 Macro ' Macro recorded 4/25/2006 by Wendy Smith 'run the macro did cells change any time a entry is made in a cell in 1244 HT-DOC 12 ThisWorkbook.Worksheets("1244...

I runt his and it seems to run fine, except that it just keeps going down the rows and not looking at For Each cell In Range("L9:M42"). Any suggestions? Sub Macro12() ' ' Macro12 Macro ' Macro recorded 4/25/2006 by Wendy Smith 'run the macro did cells change any time a entry is made in a cell...

Below is a code I created to look for a part number then I need it to put an X under each column heading where the part has been scanned. Right now this code puts an X under all column headings, I just need it to put under certain column headings. Any suggestions? Part Number LotNumber WSH TP...

Here is a report that I need to run. I can get the first part number to run, but now I need to increment myrange and rsearch. I need it to keep the same part number and ID number on the same row and when the part number changes, it is placed on a new row. Any suggestions. Part Number ID...

I created a program that goes through and reads where parts have been scanned at the plant. Now I need to change the code around to where it will put a part number on a line then put an X on the same line, but under different columns to show where the part has been scanned. Is this possible...

I have this vlookup in my code and I get the following error: unable to get the vlookup property of the worksheet function class. Can anyone help me on this. Sub update_headers() '==================================================================== ' UPDATE HEADER SHEETS...

I have this going through a source sheet once, but I need it to loop through. I have to have output(7) look at every output(1) before it makes a loop. What am I missing to get the code to do this. output(7) = "CA" + r 'dest sheet part numbers output(8) =...

I copy over a piece of information in a macro and need to reference that cell within the same macro. Can this be done?? I've tried several things and they all start looking at where the macro left off. I need the macro to look at first cell (A1) instead of the last row. Here is a small...

I need to look at information that I just copied over in a macro. How can I refer to the top row again and not to the last row. Here is a small porition of the code. Dim cellstart As Integer 'starting point of informaiton (row) Dim commentstart As Integer 'starting point for comments...

I created the following code to copy over some information, except that I just need the values copied and not the formula. I think I need to add .value, but not sure where it would go. any suggestions? r = commentsstart c = 0 c = c + 1 y = c +...

I need to have rows still calculate even if there are NA in the rows. Is this possible?

I need to calculate a column, but some of the column will have NA in them. I know that if I use the SUM in excel, my final answer would be NA. Is there anyway in VBA that I could get around it? I was looking at something like: If range("A5:A50") <> "" then range("A5:A50")=sum Still working...

I took the code for hiding rows and tried to reverse the code to unhide the rows. It does not work. Does anyone have any suggestions about unhidding rows and the being of code? Do While Sheets(destsh).Range(reportlocation).Value = ""...