unable

  1. E

    Locking specific cells

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

    Cannot filter by months in Pivot Table

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

    VBA Formula Array

    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 =...
  4. V

    VBA error, Unable to set the FormulaArray property of the Range class

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

    No Share workbook in the review tab - protect group

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

    Unable write to read - only property

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

    Need help to hide rows and columns based on cell value please

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

    Hiding rows and columns based on cell value

    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)...
  9. E

    Refresh all connections VBA

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

    Chart data table column header is misaligned, unable to fix

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

    Why am I unable to autofil this formula? =SUM('[AAL Contractor Statistics.xlsx]Summary Sheet'!$E$28:$E$87)/60

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

    Haven't used Mr. Excel for many years now LOST!

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

    Error: unable to get the match property of the worksheet function class

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

    Copying down a value in a cell until the Value Changes

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

    Unable to delete Calculated Field or Calculated Items

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

    Unable to MATCH Dates

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

    problem with "find" in VBE

    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?
  18. I

    Unable to create a table

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

    Unable to set the Hidden property of the Range Class

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

    unable to get the match property of the worksheet function class

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

Some videos you may like

This Week's Hot Topics

Top