false

I have code that was running great for more than a year. Now its adding in the formula as text so its not doing the calculation any longer "=IFERROR((INDEX(Detail!C[-2],MATCH(CMOP!RC[-1],Detail!C[-2],0))),""DELETE"")" Any help is appreciated Sub StripDown() ' ' Macro1 Macro ' If...

Hi All I have this code below, I'm trying to figure out how i can copy protected sheets and unprotect together with copying a specific range and pasting it as value only. Hoping for a quick response. Thank you! ? Sub CopySheets() Application.ScreenUpdating = False Dim MyFolder As...

Hello, I would like to deny pasting into certain columns (F:G) without disrupting that ability elsewhere. I've searched for this and have come close to a solution, but they haven't been quite right. I used the following but it restricts pasting for the entire sheet Private Sub...

Trying to updated pivot table filters of different sheets of different workbook, but the getting error message "Run-time error '-2147024809(80070057)' - The PivotTable field name is not valid... " Need help to resolve the issue and get the code running. Private Function UPivot(PName As...

Hi All I would like to copy all non-blank cells in range R5:X7000 into the adjacent cell in Range K5:Q7000 as paste values. Essentially any non-blank cells will paste as a value in same row but 7 columns to the left. I have what I think is a good piece of code but need some help how to edit it...

I have a sheet that I export to PDF using a macro below I would like to amend this to increase the PDF doc to 150% before exporting the doc Sub Export_Summary_as_PDF() Application.ScreenUpdating = False Range("Summary").Select ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF...

Hi, I have a user that logs into OneStream and gets all his data in Excel but he has several files, but I need to refresh all these files through a macro. The problem is how to I do this? I tried the following macro but it doesn't work: For Each cnct In ThisWorkbook.Connections Select case...

Good morning, The code in use is supplied below. Currently when i press my Postage Sheet Transfer Button the values are added to my worksheet and the cell in column G is applied the interior RGB colour Red. Please can you advise how i also have text in the same cell, so not only is it then...

Hi I entered 1:00 and then 2:00 in cells B2 and B3, then in B4, I used = sum(B2,B3). <colgroup><col><col><col></colgroup><tbody> istext() time1 1:00 FALSE time2 2:00 FALSE total 3:00 </tbody> so far so good, then I highlight cells B2 and B3 and changed the format to "Text"...

Still struggling a bit. I can run the code below but the target workbooks columns are not sized the same as the primary sheet. There seems to be many ways to copy so i think im trying to mix them is why i keep getting a object error. Any suggestion would be helpful in the code below i've...

I have the follow formula in cell D26...

Hello everyone, I have my userform almost done. I am able to do my searches, a it sorts the data properly. It will show first match in my form, but have added Prev and Next Buttons to look through similar matches. I am not sure how to get it to work with the search results. Here is a screen shot...

Hi Experts! I have a line item in my vba that saves an excel file in a temporary folder and then attach in an outlook email. It perfectly works on a normal laptop but when my co-worker tried it in his mac, the vba is debugging showing a run time error '1004': Microsoft Excel cannot access the...

I am using a logical 'IF' statement to distribute work to service providers. I have edited this to make it more specific however in certain circumstances the result is FALSE. The formula is below =IF(W2="","",IF(W2="Close Even","U/W Process",IF(AND(F2=1,(LEFT(E2,7))=LEFT(E1,7)),X1,IF(T2="GC -...

Could someone please help me out with this, im pretty green with coding, and the orange part is getting an error, thanks Sub Empl_Load() Dim EmpRow As Long Dim EmpCol As Long With Sheet1 If .Range("B5").Value = Empty Then MsgBox "Please enter a valid Employee from the drop down...

The code below -- created w/ help from this forum -- does a great job of cycling through a list of ~300 URLs (listed starting in cell A2 of sheet "URLs") and importing the table data from each into sheet "MXquote", pasting each chunk of table data on the first available row, such that the end...

Hello gang! Quick question hopefully with a simple answer. Why would I get a FALSE in a cell that I set = to ""? This is in a Select Case statement. TIA

Is there a way to keep the navigation pane closed or keep users from accessing it without proper permissions?

I have used this VBA code for publishing a PDF report which does work, but what it is doing is showing 2 blank pages below the PDF report been published. Is there anyway to say to the report to export just the range I want leaving just 1 page instead of throwing out good paper!. Private Sub...

Hello, Current userform has a save button, wich adds data to sheet 1, Added Search Button to find saved data for editing. If I use save button for Updated information it adds the information like new data at the bottom while old version still in the list. I added update button to use only when...