unable

Hi, I am an amateur at VBA of course. Sheet is set to visible but I am still unable to delete the VBA macro. Any suggestion on how to solve this issue?

Hi all, I have written a code to link a slicer to multiple charts/graphs. But Unable to connect it because it shows ar error stating "Unable to get pivotTables property of the worksheet class". can anyone help me with this. Below is the my code for connecting slicer with multiple...

Hi Gurus, I'm new in VBA and I do need some help for the following codes. In Excel file, my code works fine but not in VBA. In Excel file, my codes are as follows: =IF(E2="","Not Found", IF(COUNTIFS(E:E,E2,F:F,F2)>1, IF(COUNTIFS(E$1:E2,E2,F$1:F2,F2)=1, SUMIFS('Traffic Report'!$L:$L,'Traffic...

Good Morning Everyone, I was given an excel file that is password protected and I have the password. However, I am unable to scroll past certain points of sheets. When I drag my scroll bar it resorts back to a certain column. I am also unable to select an entire column or row. I tried a few...

Need help completing my project. https://www.flickr.com/photos/upload/

Hi, To the file below, why can't I run the macro inside it? https://1drv.ms/x/s!Ai8CrEskdewXm1EtunChN-NFqXkj

I am receiving the "unable to get the vlookup property of the worksheet fuction class" error on the line below. Set RngStart = Application.WorksheetFunction.VLookup(StartDate, SearchArray, 2, False) The variable StartDate and SearchArray are constructed with the code below. StartDate =...

Iam unable to see the code in developer view.

Hi all, I have a workbook that logs daily production totals. I am able to count totals for production between dates but for the life of me are unable to figure out how to count the employees. I'm using =SUMIFS(DataBase!H:H,DataBase!A:A,">="&$P$1,DataBase!A:A,"<="&$P$2,DataBase!S:S,O4) to...

I'm going to try to explain the best I can! I have an excel open (Workbook1) currently. There are part numbers in Column A. I need a VBA to go to a folder named "Pipe" on my desktop and open the Last Modified file(Workbook2). Once open the VBA needs to go to the "Workbook1" and create a new...

I am unable to get sum total for the following dataset: the columns are as follows: NO. PAYMENT AMOUNT INTEREST PRINCIPAL (D11:D1054) DATE WHEN PAYMENT IS DUE (I11:I1054) MY FOLLOWING FORMULA FAILS AND I AM OUT OF LUCK! =SUMIFS(D11:D1054,I11:I1054,"YEAR(2017)") I AM TRYING TO CALCULATE...

Why am I unable to manually adjust the range when I click into the cell containing the formula? Here is an image to help you understand what I am trying to say. https://drive.google.com/file/d/1_j1nrgmbt7ZVfkLaId7FVLSM6q7Pqdfk/view?usp=sharing

Got this intranet website only accessible at work( so unable to provide link) but I've included the html code relevant to a drop down menu. I'm unable to get a handle on it , have tried by class, name tag, and id using.getelement/s method. There are two such drop down boxes and strangely enough...

Exporting USDA data for a proprietary spreadsheet , but unable to match the 4-digit Year column data formatting with it's appropriate reference cell. Other column data matches (State, Commodity, etc). Character length is equal as they each are four characters. However the cells do not equal...

I Have a data workshhet where data is set by columns. but when I add new column a error is display" unable to get Worksheet.Function match class" what can I do

Within a longer macro I've included the following Dim readingdate As String Dim yrstart As Date yrstart = Application.WorksheetFunction.VLookup(readingdate, Sheets("Lookups").Range("B7:E19"), 4, False) but it returns an error "Unable to get the VLookup propertry of the Worksheetfunction...

I am unable to attache excel files of the data. Please guide how it can be done.

Greetings, I am receiving the error "Unable to get the Pearson Property of the WorksheetFunction Class" Runtime Error on the line below. Arg1 and Arg2 are both Range variables. J, and i are integer variables. I would like the value of Cells(j,i) to be the value of the Pearson...

for what ever reason I am unable to paste a VB code in a thread. Any ideas why this would be?

I'm working with a large excel doc that has several tabs. Trying to create a formula to tell me if there's an account number listed in column A AND if it has an X in column DJ for that specific account. If both the account number and the X in DJ are there I need an X in the new cell. I am...