unable

Hi all, I need some help fixing this code. Worksheets("Sheet1").Range("A6:A167").Locked = FalseWorksheets("Sheet1").Range("C6:C167").Locked = False ActiveSheet.Protect Password:="abc" I am trying to lock those specific ranges, but it keeps throwing an error every time I try to implement it...

https://1drv.ms/x/s!AvjBsEPEq12ngURD4J_Yxbfrn7OV?e=ln2Olm I have a sheet of data. I converted it to a table. Loaded it into Power Query, unpivoted the dates columns, and then created a pivot table. But I want to be able to choose the months in the pivot table, but I'm unable to do so. What do...

Hello, I am trying to input below formula array into a cell M11, it returns me an error massage "Unable to set the FormulaArray property of the Range class": lastrow_AFGR2 = Sheets("AFGR").Range("D:D").Find(what:="*", searchdirection:=xlPrevious).Row Range("M11").FormulaArray =...

Hi All, Please help me solving this error. I have read several post on this error but still I am unable still unable to find solution. This error occurs since below array formula have extended more than 255 char. Please help me how should I break this formula to make my code work. I am using...

Hi , I can see only 'unshare workbook' which is greyed , how to get it to 'share'. I am unable to fix it going to the options

Tôi có một mã vbs. Khi tôi chạy nó để cập nhật dữ liệu từ tệp excel sang ứng dụng SAPGUI, tôi nhận được thông báo lỗi "Không thể ghi vào chỉ đọc thuộc tính '" . AI có thể cho tôi biết nguyên nhân và cách khắc phục. cảm ơn bạn mã vbs: Dim objExcel, objWorkbook, objSheet, i Set objExcel =...

i am new and i need massive help please. please be generous as i am new. i am trying to create spreadsheet based on cell value with dropdown list (All,a,b,c,d) - if cell A1 = ALL range a5:j20 shows everthing (neither row or column hide). if A1="a" then row(s) and column(s) contain "a" hide...

afternoon all, i am new and i need massive help please. please be generous as i am new. i am trying to create spreadsheet based on cell value with dropdown list (All,a,b,c,d) - if cell A1 = ALL range a5:j20 shows everthing (neither row or column hide). if A1="a" then row(s) and column(s)...

Some of my workbooks have a connection that pulls data from a website. I need to batch open those workbooks and update the connection. The problem is that the code is not working, I suppose that's because I was unable to be "BackgroundQuery: = False" before reflashall and not wait until update...

See the included screenshot of the issue. Despite how it appears, the charts are NOT Pivot Charts. Instead, the pivot data is feeding a table that's located elsewhere on the page. This file is massive and would be quite difficult to share (privacy issues, as well), so I'm regrettably unable to...

Apologies for including the formula in the title. I was unable to paste I in here. Any advice as to why I'm unable to fill the formula? I've tried other formulas and they auto fill, but not this one. Do I perhaps need to do it as a vlookup? If so, any help would be greatly appreciated. T

I'm essentially new to Mr. Excel and am trying to post a question about an error I'm getting In what should be a simple line of code. Not sure where to begin -seems I am unable to post net threads in most forums. If you could please let me know where to begin.... Thanks in advance

Dear Good People, I am having this error message: unable to get the match property of the worksheet function class. Below is my code where iam getting These Problem. Let me know what should i corret.Thanks For i = 15 To 1000 If Worksheets("Sheet1").Cells(0 + i, 6) > 3 Then...

Hi I am struggling to work out a formula for the below scenario: In Column A1 123 456 789 In Column B1 I am looking to copy the value in A1, filling in the blanks with the same value until a new value is reached in A1. The Ideal result would be in B1 123 123 123 123 456 456 456 456...

I am unable to delete calculated fields OR calculated items in a pivot table. The DELETE button is simply greyed out; when selecting the calculated field or item. Workbook has no macros, is not protected in anyway.

I'm trying to use this code (red line) to determine what row the current date can be found in column B of the worksheet. With ws_wstoview If .Visible = xlSheetVisible Then .Visible = xlSheetHidden Worksheets("FRONT").Activate...

When I try to use the "find" box it appears, rather large and with the buttons off screen, to the right. So far I have been unable to find how to control it - can anyone help, please?

Hi, I wish to create a table from a column on another worksheet from where the drop down sheet is used but unable to. When i select all the cells in question then click insert table i see that the table icon is greyed out. I think there is already a table in place for this column on another...

Dear Demigods, I am using the following VBA: Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Target.Address(0, 0) = "B14" Then Cancel = True Rows("15:38").Hidden = Not Rows("15:38").Hidden End If End Sub The codes works well until i come to...

I am receiving the error "unable to get the match property of the worksheet function class". I suspect my data as input into the function is not allowing for the smooth operation of the function. Below is the code. C = TS.Cells(A, "A").value D = TS.Cells(A, "B").value E = TS.Cells(A...