failed

I have a bit of code that has been working fine for years, but now suddenly get feedback from some users that my error catching shows them "Insert method of range class failed". The simplified version of my code is the following: Sub AddLine() On Error GoTo ErrCatch Set Sht =...

Hi +$d$8 (where the date is in a date formated field) +(g17x7) does not work. G17 is weeks post award. 7 (days of the week) all I keep getting is value. I tried in a different cell +$d$8+14 and that failed too. Anyone know why? I get the usual hopeless #value MS message. Thanks

How do I successfully nest multiple AND and OR's along the same row? For example, I want to check if K3=V AND AP3 or AR3 or AT3 or AV3 or AX3 or AZ3 or BB3 or BD3 or BF3 or BH3="L" then TRUE, otherwise FALSE. I tried but failed spectacularly.

I am running a macro that saves a certain cell data to a property in sharepoint metadata. It works great. But, there's always a but, there are times that the string has a comma, then an intentional space at the end. When that is the case, I receive the following error: "method value of object...

Hello, I have the following spreadsheet. I would like to add data validation to Row 4 to look at Cells 46 and 49. So basically what I would like to do is not allow the operator to fill out the next column of data IF cell 46 says Failed and cell 49 does not have text in it. If cell 46 says...

Hi All, Using 3 lines of code below i run into error 1004 autofilter method of range class failed on the last line. Range("C12:P12").Select Selection.SpecialCells(xlCellTypeVisible).Select Selection.AutoFill Destination:=Range("C12:P12"), Type:=xlFillWeekdays Could someone please help...

I hope someone can assist with this question. I require to understand the number of characters behind the final '\' character. Example: Monday\Tuesday\Wednesday Answer in next cell = 14 (14 characters behind the final '\') Or is a possible solution to count where the final '\' is in a...

How can I create a macro to delete many columns. I need the below columns deleted. I tried but failed.... Range("B:S,C:C,E:E,G:G,I:I,K:K,M:M,O:O,Q:Q,S:S,U:U,W:W,Y:Y,AA:AA,AC:AC,AE:AE,AG:AG,AI:AI,AK:AK,AM:AM,AO:AO,AQ:AQ,AS:AS,AU:AU,AW:AW,AY:AY, _...

While working on a spreadsheet at work, I was getting the error "method open of object workbooks failed", but when I got home, the same file was not giving me any errors. Any ideas why?

Hi Can I copy a sheet from ThisWorkbook to another workbook which is closed but in the same folder. Is that possible or the second workbook has to be open. I know how to move/copy a sheet inside same workbook or to another opened workbook but my code below failed to copy a sheet to second...

I am trying to conditional format a row to accomplish this. I need cell A1 when it contains the text “Sell” to fill color, Cells (A6:A10) to turn lets say Green. Every thing I have tried so far has failed, this is just one of several formulas I have used IF(C6="Sell",IF(B6:B10)) Thanks in...

Can somebody please help to identify what mistake am i committing? I'm using Excel 2010 Running macro gives me the message that... Run time error 1004 Method 'SaveAs' of object' _workbook' failed Here is how I set up the file format If Val(Application.Version) < 12 Then FileExtStr =...

Hello guys, I need your help. My created a long formula in Excel and I need to convert it to VBA. I've been trying a couple of things, but always failed. Can you please help me? So the formula (for example for cell G50) looks like this...

Good afternoon! I pulled several thousand formulas into a spreadsheet and brought them in with the ' front of the =. Now that I have modified the formulas and am ready to calculate them all I need to get rid of the '. I've tried a dozen or more methods of doing this and have failed every time...

Hi, i have the following: <tbody> Name Pass Rate Previous Score Accumulative Points Accumulative minus Reduction Result Value John 100.00% #DIV/0! 89 89 PASSED 89 Luke 0.00% 0 0 0 FAILED 44 George 100.00% 0 82 82 PASSED 82 Tim 100.00% 0 95 95 PASSED 95 Luke 0.00% 44 0 0 FAILED 63...

Hi, Trying to amend the code to include in the message box details of failed items. So in the active column, I have some cells indicating "FAILED". in the adjacent columns I have data in Column A and B. How will the below code be amended so it lists the corresponding data in Column A and B...

Dears I need your help My data is as follow <tbody> Name Status Pro1 Successful Pro1 Failed Pro2 Failed Pro2 Failed Pro3 Successful Pro3 Successful Pro4 Successful </tbody> And what I want is retrieve the names without duplication and this criteria for the status <tbody> If...

I have excel Com Add-in it's name Mapcite for maps I want to open it in a frame inside userform. how can I do that I tried many ways but unfortunately all failed. I afraid this is cannot happened and I just lose time Thank you Excel Masters and my colleagues, for always support.

Hey guys I have a macro that has always worked. Now suddenly it will not load in my XLStart folder when opening a document and when I try to go into the macro it states: Run-time error 50290: Method 'LinkSources' of object '_Workbook' failed Does anyone know how I go about fixing this?

Hi Everybody, I know this is one is probably an easy one for you all. I have a long error report with over 10k lines I need help with. Attached is a sample of the spreadsheet. Column J shows which line the error is located on on the spreadsheet. Is there a way to highlight the row where the...