A problem with Excel vba code?

01 January 2017 1 3K Report

I have a problem with simple Excel vba code below, I just need to perform goal seek for many cell in one sheet (tsheet) and put the answer in another sheet (asheet).

Sub compute()

Worksheets("tsheet").Range("F16:Z335").GoalSeek Goal:=0, _

ChangingCell:=Worksheets("asheet").Range("F16:Z335")

End Sub

I got runtime error 1004. Is there any help.

Thanks

Amro Mohamed Elfeki

Thanks Ahmed

Can you send me your e-mail?

Badges
Science topic

More Amro Mohamed Elfeki's questions See All

Is there an explicit expression for the inversion of Pearson CDF or Log-Pearson CDF?

Inversion of CDF

10 November 2013 9,896 3 View

How to perform matrix LU De-composition on Excel?

I am looking for a way to perform matrix LU De-composition on Excel, any help is appreciated?

03 April 2013 6,973 8 View

What is a simple way to model 2d flow in an arid urbanized area due to flash floods?

I would like to find out a simple model for solving Saint Vanint equation in 2d. Is there a free software can do this?

31 December 2012 8,875 0 View

error in running a model in Abaqus

Excessive rotation of nodes in node set ErrNodeExcessRotation-Step1

17 August 2021 0 0 View

error in modelling model in Abaqus

Excessive rotation of nodes in node set ErrNodeExcessRotation-Step1

17 August 2021 0 0 View

MGL tools

20 June 2021 0 0 View

i have some problem with chtMultiRegionSimpleFoam

--> FOAM FATAL ERROR: Maximum number of iterations exceeded From function Foam::scalar Foam::species::thermo::T(Foam::scalar, Foam::scalar, Foam::scalar, Foam::scalar (Foam::species::thermo::*)(Foam::scalar, Foam::scalar) const, Foam::scalar (Foam::species::thermo::*)(Foam::scalar, Foam::scalar) const, Foam::scalar (Foam::species::thermo::*)(Foam::scalar) const) const [with Thermo = Foam::hConstThermo >; Type = Foam::sensibleEnthalpy; Foam::scalar = double; Foam::species::thermo = Foam::species::thermo >, Foam::sensibleEnthalpy>] in file /home/ubuntu/OpenFOAM/OpenFOAM-4.1/src/thermophysicalModels/specie/lnInclude/thermoI.H at line 66. FOAM aborting #0 Foam::error::printStack(Foam::Ostream&) at ??:? #1 Foam::error::abort() at ??:? #2 Foam::heRhoThermo >, Foam::sensibleEnthalpy> > > >::calculate() at ??:? #3 Foam::heRhoThermo >, Foam::sensibleEnthalpy> > > >::correct() at ??:? #4 ? at ??:? #5 __libc_start_main in "/lib/x86_64-linux-gnu/libc.so.6" #6 ? at ??:?

24 March 2021 0 0 View

Why does blocking with my immunogenic peptide cause nuclear fluorescence in ICC?

Hi all, I am validating a polyclonal antibody raised against human ANT4, through WB and ICC. In most of my controls, the antibody shows very little off-target binding, but when I pre-incubate the...

03 March 2021 5,999 3 View

Resistor definition in Piezoelectric bimorph with ANSYS workbench

Hello, good day! I am trying to simulate similar bimorph piezoelectric harvester with below commands. However, the output power doesn't change with resistor value. Please help to find the reason. ET,10,CIRCU94,0 !SET UP RESISTOR R,1,100000 !RESISTANCE VALUE TYPE,10 !SET ELEMENT TYPE E,1,2 !CREATE RESISTOR BETWEEN NODES 1 AND 2 Thanks in advance Regards,

02 March 2021 0 0 View

How to code open-ended questions in SPSS?

Hello all, In SPSS I am going to code 2 open-ended questions. I have already read all the answers and I made a list of the most important categories to which I can code the answers. This question...

02 March 2021 1,757 4 View

The procedure compute?

02 March 2021 5,204 3 View

Is there a powerful system for the security of the systems distributed on IoT systems?

02 March 2021 3,858 10 View

Does Napabucasin soluble in dichloromethane and in ethanol?

I need to prepare a solution of Napabucasin (inhibitor of cancer cell stemness) in dichloromethane. The drug is expensive, so maybe somebody already tried to do it. If it is soluble, what is the...

02 March 2021 9,945 3 View