excel error

Hello All, New to this forum as well as VBA, so i would appreciate some insight. This is probably a simple fix, but i am not able to solve the issue. I have received the following error for the code in the module i am building. I have tried simple fixes ( adding and removing paste, changing...

How to marge 3 table into one table , because i face reference error , i tried......, pleased solving this query.... step by step.

i deleted this file but excel opening time show this how remove this Error in microsoft excel365........ Pleased help me.......

Hi there, PLEASE HELP!!!! I'm desperate with this annoying error messaing! Can I make it not to show? Application.displayalerts=False , is not working! I have named ranges, but of course, if the sheet has no data, the ranges and the graphs attached to that no work. But I know that! I just...

I am creating a spreadsheet where I am averaging numbers acrosscolumns B through K. An example of theformula is: (row 23) =IFERROR(AVERAGE(B23:K23),"0") **Formula created in column L** (row 24) =IFERROR(AVERAGE(B24:K24),”0”) **Formula created in column O** This...

Guys, Help please! Im trying to figure out what’s the problem here, I’ve checked all the areas but still im getting the same error. Excel keeps on pushing to restart or close my template. Here’s what happened. When I have entered a numeric values in my target cell, excel works fine. But...

Hello all, Has anyone else received this error? I have narrowed down the line that causes the error (bold in red below in second sub) but can't seem to fix it. I recently got a new computer using 64 bit Excel 2016. PLEASE HELLLPP!!!! Function AddConnections() As Integer'Adds data...

=COUNTIFS('\\aweta\user\profile\jooms\Desktop\[Sofon-sheet.xlsm]New'!$M$2:$M$93356;$C$1;'\\aweta\user\profile\jooms\Desktop\[Sofon-sheet.xlsm]New'!$P$2:$P$93356;">="&$D$2;'\\aweta\user\profile\jooms\Desktop\[Sofon-sheet.xlsm]New'!$P$2:$P$93356;"<="&$E$2) When I open my main sheet (called...

Happy Autumn! I am trying to flag a cell, pointing to 2 different cells, if the following condition is met: 1. For cell A1: If(C1-C2)/C1>.15 --> Red stoplight. 2. For cell A1: If(C1-C2)/C1>.05 --> Yellow stoplight. 3. For cell A1: If(C1-C2)/C1<=0.05 --> Green stoplight. This is working fine...

Why Excel always error and stop during run follow code? [let Cells(2,2)=10] Private Sub CommandButton1_Click() Cells(2, 1) = 0 Call StartData End Sub Private Declare Function SetTimer Lib "user32" (ByVal hWnd As Long, ByVal nIDEvent As Long, ByVal uElapse As Long, ByVal lpTimerFunc As Long)...

Hello, I have a Charting AddIn (created in 2004), which formats selected data into different charts. All of the charts work well, except: Pie, Pie of Pie, Bar of Pie and Doughnut. For those types of charts I get the following error: Error No: 2147483643 Description: This object is no longer...

Hi, we have nice tracking file in excel at work. However that is also the one file that gives various errors. It does so on all computers, both when file is on network, and also if we try it with a local copy on Cdrive. When opening the file it warns that "excel cannot complete the task with...

Does anyone have experience working and building apps in Excel '13? I have an Excel 2013 .xlsm workbook that has multiple tabs. One tab contains an App I created. On the machine which I created the workbook, everything works perfectly fine. However, when I test on other machines, one of them...

Hey everyone. I'm trying to run some code but I keep getting the Object Variable or With Block Variable Not Set message. I'm not using any object in the line that is causing the error. Could someone take a look at the code and let me know what I'm doing wrong? I'm getting an error on the last...

Hi all, If I double click ANY Excel file it won't open. Instead the Excel program will open, just without the workbook I tried opening. Clicking again and the workbook will open. So in summary, I need Excel already open otherwise my workbook won't open. I've looked online and the only...

I am using a max function to find the max of an array found by multiplying two conditions to arrive at a single array: =MAX((Data!$B$3:$B$202=Analysis!$B4)*(Data!F$3:F$202)) where the first condition is used as a true false (1 or 0) to only count the following condition when it is met. It...

Hi all, i have some difficulty in understanding the purpose of both types of variables in excel macro. Furthermore, i have a problem in my codes right now, Dim TotalRow As Integer Set TotalRow = ActiveSheet.Rows.Count ActiveCell.Copy For i = 1 To TotalRow...