Conditional average function

[Andres]

I have a VBA code to calculate a "conditional average" of the days used to issued official documents, given a range, and ID of the entity and the column I want to calculate.
When I use the function in the same sheet I have the information to be calculated, it works well. However, when using it in a different sheet (of the same workbook), an error message is displayed.
It seems there's a reference problem when working with ranges, but I have not found how to solve it.
Does anybody know what should I change for this function to work properly?
Thank you very much in advance!

[Bob Phillips]

The code is?

Could well be unqualified ranges, such as

Worksheets("Sheet1").Range(Cells(A,1),Cells(2,2))

The Range refers to Sheet1 as it is qualified, but the Cells refer to the
active sheet as they are not.

--
HTH

Bob Phillips

"Andres" <[email protected]> wrote in
message news:[email protected]...
>
> I have a VBA code to calculate a "conditional average" of the days used
> to issued official documents, given a range, and ID of the entity and
> the column I want to calculate.
> When I use the function in the same sheet I have the information to be
> calculated, it works well. However, when using it in a different sheet
> (of the same workbook), an error message is displayed.
> It seems there's a reference problem when working with ranges, but I
> have not found how to solve it.
> Does anybody know what should I change for this function to work
> properly?
> Thank you very much in advance!
>
>
> --
> Andres
> ------------------------------------------------------------------------
> Andres's Profile:
http://www.excelforum.com/member.php...o&userid=26096
> View this thread: http://www.excelforum.com/showthread...hreadid=394273
>

[Bob Phillips]

The code is?

Could well be unqualified ranges, such as

Worksheets("Sheet1").Range(Cells(A,1),Cells(2,2))

The Range refers to Sheet1 as it is qualified, but the Cells refer to the
active sheet as they are not.

--
HTH

Bob Phillips

"Andres" <[email protected]> wrote in
message news:[email protected]...
>
> I have a VBA code to calculate a "conditional average" of the days used
> to issued official documents, given a range, and ID of the entity and
> the column I want to calculate.
> When I use the function in the same sheet I have the information to be
> calculated, it works well. However, when using it in a different sheet
> (of the same workbook), an error message is displayed.
> It seems there's a reference problem when working with ranges, but I
> have not found how to solve it.
> Does anybody know what should I change for this function to work
> properly?
> Thank you very much in advance!
>
>
> --
> Andres
> ------------------------------------------------------------------------
> Andres's Profile:
http://www.excelforum.com/member.php...o&userid=26096
> View this thread: http://www.excelforum.com/showthread...hreadid=394273
>

[Bob Phillips]

The code is?

Could well be unqualified ranges, such as

Worksheets("Sheet1").Range(Cells(A,1),Cells(2,2))

The Range refers to Sheet1 as it is qualified, but the Cells refer to the
active sheet as they are not.

--
HTH

Bob Phillips

"Andres" <[email protected]> wrote in
message news:[email protected]...
>
> I have a VBA code to calculate a "conditional average" of the days used
> to issued official documents, given a range, and ID of the entity and
> the column I want to calculate.
> When I use the function in the same sheet I have the information to be
> calculated, it works well. However, when using it in a different sheet
> (of the same workbook), an error message is displayed.
> It seems there's a reference problem when working with ranges, but I
> have not found how to solve it.
> Does anybody know what should I change for this function to work
> properly?
> Thank you very much in advance!
>
>
> --
> Andres
> ------------------------------------------------------------------------
> Andres's Profile:
http://www.excelforum.com/member.php...o&userid=26096
> View this thread: http://www.excelforum.com/showthread...hreadid=394273
>

[Bob Phillips]

The code is?

Could well be unqualified ranges, such as

Worksheets("Sheet1").Range(Cells(A,1),Cells(2,2))

The Range refers to Sheet1 as it is qualified, but the Cells refer to the
active sheet as they are not.

--
HTH

Bob Phillips

"Andres" <[email protected]> wrote in
message news:[email protected]...
>
> I have a VBA code to calculate a "conditional average" of the days used
> to issued official documents, given a range, and ID of the entity and
> the column I want to calculate.
> When I use the function in the same sheet I have the information to be
> calculated, it works well. However, when using it in a different sheet
> (of the same workbook), an error message is displayed.
> It seems there's a reference problem when working with ranges, but I
> have not found how to solve it.
> Does anybody know what should I change for this function to work
> properly?
> Thank you very much in advance!
>
>
> --
> Andres
> ------------------------------------------------------------------------
> Andres's Profile:
http://www.excelforum.com/member.php...o&userid=26096
> View this thread: http://www.excelforum.com/showthread...hreadid=394273
>

[Bob Phillips]

The code is?

Could well be unqualified ranges, such as

Worksheets("Sheet1").Range(Cells(A,1),Cells(2,2))

The Range refers to Sheet1 as it is qualified, but the Cells refer to the
active sheet as they are not.

--
HTH

Bob Phillips

"Andres" <[email protected]> wrote in
message news:[email protected]...
>
> I have a VBA code to calculate a "conditional average" of the days used
> to issued official documents, given a range, and ID of the entity and
> the column I want to calculate.
> When I use the function in the same sheet I have the information to be
> calculated, it works well. However, when using it in a different sheet
> (of the same workbook), an error message is displayed.
> It seems there's a reference problem when working with ranges, but I
> have not found how to solve it.
> Does anybody know what should I change for this function to work
> properly?
> Thank you very much in advance!
>
>
> --
> Andres
> ------------------------------------------------------------------------
> Andres's Profile:
http://www.excelforum.com/member.php...o&userid=26096
> View this thread: http://www.excelforum.com/showthread...hreadid=394273
>

[Bob Phillips]

The code is?

Could well be unqualified ranges, such as

Worksheets("Sheet1").Range(Cells(A,1),Cells(2,2))

The Range refers to Sheet1 as it is qualified, but the Cells refer to the
active sheet as they are not.

--
HTH

Bob Phillips

"Andres" <[email protected]> wrote in
message news:[email protected]...
>
> I have a VBA code to calculate a "conditional average" of the days used
> to issued official documents, given a range, and ID of the entity and
> the column I want to calculate.
> When I use the function in the same sheet I have the information to be
> calculated, it works well. However, when using it in a different sheet
> (of the same workbook), an error message is displayed.
> It seems there's a reference problem when working with ranges, but I
> have not found how to solve it.
> Does anybody know what should I change for this function to work
> properly?
> Thank you very much in advance!
>
>
> --
> Andres
> ------------------------------------------------------------------------
> Andres's Profile:
http://www.excelforum.com/member.php...o&userid=26096
> View this thread: http://www.excelforum.com/showthread...hreadid=394273
>

[Bob Phillips]

The code is?

Could well be unqualified ranges, such as

Worksheets("Sheet1").Range(Cells(A,1),Cells(2,2))

The Range refers to Sheet1 as it is qualified, but the Cells refer to the
active sheet as they are not.

--
HTH

Bob Phillips

"Andres" <[email protected]> wrote in
message news:[email protected]...
>
> I have a VBA code to calculate a "conditional average" of the days used
> to issued official documents, given a range, and ID of the entity and
> the column I want to calculate.
> When I use the function in the same sheet I have the information to be
> calculated, it works well. However, when using it in a different sheet
> (of the same workbook), an error message is displayed.
> It seems there's a reference problem when working with ranges, but I
> have not found how to solve it.
> Does anybody know what should I change for this function to work
> properly?
> Thank you very much in advance!
>
>
> --
> Andres
> ------------------------------------------------------------------------
> Andres's Profile:
http://www.excelforum.com/member.php...o&userid=26096
> View this thread: http://www.excelforum.com/showthread...hreadid=394273
>

[Bob Phillips]

The code is?

Could well be unqualified ranges, such as

Worksheets("Sheet1").Range(Cells(A,1),Cells(2,2))

The Range refers to Sheet1 as it is qualified, but the Cells refer to the
active sheet as they are not.

--
HTH

Bob Phillips

"Andres" <[email protected]> wrote in
message news:[email protected]...
>
> I have a VBA code to calculate a "conditional average" of the days used
> to issued official documents, given a range, and ID of the entity and
> the column I want to calculate.
> When I use the function in the same sheet I have the information to be
> calculated, it works well. However, when using it in a different sheet
> (of the same workbook), an error message is displayed.
> It seems there's a reference problem when working with ranges, but I
> have not found how to solve it.
> Does anybody know what should I change for this function to work
> properly?
> Thank you very much in advance!
>
>
> --
> Andres
> ------------------------------------------------------------------------
> Andres's Profile:
http://www.excelforum.com/member.php...o&userid=26096
> View this thread: http://www.excelforum.com/showthread...hreadid=394273
>

[Bob Phillips]

The code is?

Could well be unqualified ranges, such as

Worksheets("Sheet1").Range(Cells(A,1),Cells(2,2))

The Range refers to Sheet1 as it is qualified, but the Cells refer to the
active sheet as they are not.

--
HTH

Bob Phillips

"Andres" <[email protected]> wrote in
message news:[email protected]...
>
> I have a VBA code to calculate a "conditional average" of the days used
> to issued official documents, given a range, and ID of the entity and
> the column I want to calculate.
> When I use the function in the same sheet I have the information to be
> calculated, it works well. However, when using it in a different sheet
> (of the same workbook), an error message is displayed.
> It seems there's a reference problem when working with ranges, but I
> have not found how to solve it.
> Does anybody know what should I change for this function to work
> properly?
> Thank you very much in advance!
>
>
> --
> Andres
> ------------------------------------------------------------------------
> Andres's Profile:
http://www.excelforum.com/member.php...o&userid=26096
> View this thread: http://www.excelforum.com/showthread...hreadid=394273
>

[Bob Phillips]

The code is?

Could well be unqualified ranges, such as

Worksheets("Sheet1").Range(Cells(A,1),Cells(2,2))

The Range refers to Sheet1 as it is qualified, but the Cells refer to the
active sheet as they are not.

--
HTH

Bob Phillips

"Andres" <[email protected]> wrote in
message news:[email protected]...
>
> I have a VBA code to calculate a "conditional average" of the days used
> to issued official documents, given a range, and ID of the entity and
> the column I want to calculate.
> When I use the function in the same sheet I have the information to be
> calculated, it works well. However, when using it in a different sheet
> (of the same workbook), an error message is displayed.
> It seems there's a reference problem when working with ranges, but I
> have not found how to solve it.
> Does anybody know what should I change for this function to work
> properly?
> Thank you very much in advance!
>
>
> --
> Andres
> ------------------------------------------------------------------------
> Andres's Profile:
http://www.excelforum.com/member.php...o&userid=26096
> View this thread: http://www.excelforum.com/showthread...hreadid=394273
>

[Bob Phillips]

The code is?

Could well be unqualified ranges, such as

Worksheets("Sheet1").Range(Cells(A,1),Cells(2,2))

The Range refers to Sheet1 as it is qualified, but the Cells refer to the
active sheet as they are not.

--
HTH

Bob Phillips

"Andres" <[email protected]> wrote in
message news:[email protected]...
>
> I have a VBA code to calculate a "conditional average" of the days used
> to issued official documents, given a range, and ID of the entity and
> the column I want to calculate.
> When I use the function in the same sheet I have the information to be
> calculated, it works well. However, when using it in a different sheet
> (of the same workbook), an error message is displayed.
> It seems there's a reference problem when working with ranges, but I
> have not found how to solve it.
> Does anybody know what should I change for this function to work
> properly?
> Thank you very much in advance!
>
>
> --
> Andres
> ------------------------------------------------------------------------
> Andres's Profile:
http://www.excelforum.com/member.php...o&userid=26096
> View this thread: http://www.excelforum.com/showthread...hreadid=394273
>

[Bob Phillips]

The code is?

Could well be unqualified ranges, such as

Worksheets("Sheet1").Range(Cells(A,1),Cells(2,2))

The Range refers to Sheet1 as it is qualified, but the Cells refer to the
active sheet as they are not.

--
HTH

Bob Phillips

"Andres" <[email protected]> wrote in
message news:[email protected]...
>
> I have a VBA code to calculate a "conditional average" of the days used
> to issued official documents, given a range, and ID of the entity and
> the column I want to calculate.
> When I use the function in the same sheet I have the information to be
> calculated, it works well. However, when using it in a different sheet
> (of the same workbook), an error message is displayed.
> It seems there's a reference problem when working with ranges, but I
> have not found how to solve it.
> Does anybody know what should I change for this function to work
> properly?
> Thank you very much in advance!
>
>
> --
> Andres
> ------------------------------------------------------------------------
> Andres's Profile:
http://www.excelforum.com/member.php...o&userid=26096
> View this thread: http://www.excelforum.com/showthread...hreadid=394273
>

[Bob Phillips]

The code is?

Could well be unqualified ranges, such as

Worksheets("Sheet1").Range(Cells(A,1),Cells(2,2))

The Range refers to Sheet1 as it is qualified, but the Cells refer to the
active sheet as they are not.

--
HTH

Bob Phillips

"Andres" <[email protected]> wrote in
message news:[email protected]...
>
> I have a VBA code to calculate a "conditional average" of the days used
> to issued official documents, given a range, and ID of the entity and
> the column I want to calculate.
> When I use the function in the same sheet I have the information to be
> calculated, it works well. However, when using it in a different sheet
> (of the same workbook), an error message is displayed.
> It seems there's a reference problem when working with ranges, but I
> have not found how to solve it.
> Does anybody know what should I change for this function to work
> properly?
> Thank you very much in advance!
>
>
> --
> Andres
> ------------------------------------------------------------------------
> Andres's Profile:
http://www.excelforum.com/member.php...o&userid=26096
> View this thread: http://www.excelforum.com/showthread...hreadid=394273
>

[Bob Phillips]

The code is?

Could well be unqualified ranges, such as

Worksheets("Sheet1").Range(Cells(A,1),Cells(2,2))

The Range refers to Sheet1 as it is qualified, but the Cells refer to the
active sheet as they are not.

--
HTH

Bob Phillips

"Andres" <[email protected]> wrote in
message news:[email protected]...
>
> I have a VBA code to calculate a "conditional average" of the days used
> to issued official documents, given a range, and ID of the entity and
> the column I want to calculate.
> When I use the function in the same sheet I have the information to be
> calculated, it works well. However, when using it in a different sheet
> (of the same workbook), an error message is displayed.
> It seems there's a reference problem when working with ranges, but I
> have not found how to solve it.
> Does anybody know what should I change for this function to work
> properly?
> Thank you very much in advance!
>
>
> --
> Andres
> ------------------------------------------------------------------------
> Andres's Profile:
http://www.excelforum.com/member.php...o&userid=26096
> View this thread: http://www.excelforum.com/showthread...hreadid=394273
>

[Bob Phillips]

The code is?

Could well be unqualified ranges, such as

Worksheets("Sheet1").Range(Cells(A,1),Cells(2,2))

The Range refers to Sheet1 as it is qualified, but the Cells refer to the
active sheet as they are not.

--
HTH

Bob Phillips

"Andres" <[email protected]> wrote in
message news:[email protected]...
>
> I have a VBA code to calculate a "conditional average" of the days used
> to issued official documents, given a range, and ID of the entity and
> the column I want to calculate.
> When I use the function in the same sheet I have the information to be
> calculated, it works well. However, when using it in a different sheet
> (of the same workbook), an error message is displayed.
> It seems there's a reference problem when working with ranges, but I
> have not found how to solve it.
> Does anybody know what should I change for this function to work
> properly?
> Thank you very much in advance!
>
>
> --
> Andres
> ------------------------------------------------------------------------
> Andres's Profile:
http://www.excelforum.com/member.php...o&userid=26096
> View this thread: http://www.excelforum.com/showthread...hreadid=394273
>

[Bob Phillips]

The code is?

Could well be unqualified ranges, such as

Worksheets("Sheet1").Range(Cells(A,1),Cells(2,2))

The Range refers to Sheet1 as it is qualified, but the Cells refer to the
active sheet as they are not.

--
HTH

Bob Phillips

"Andres" <[email protected]> wrote in
message news:[email protected]...
>
> I have a VBA code to calculate a "conditional average" of the days used
> to issued official documents, given a range, and ID of the entity and
> the column I want to calculate.
> When I use the function in the same sheet I have the information to be
> calculated, it works well. However, when using it in a different sheet
> (of the same workbook), an error message is displayed.
> It seems there's a reference problem when working with ranges, but I
> have not found how to solve it.
> Does anybody know what should I change for this function to work
> properly?
> Thank you very much in advance!
>
>
> --
> Andres
> ------------------------------------------------------------------------
> Andres's Profile:
http://www.excelforum.com/member.php...o&userid=26096
> View this thread: http://www.excelforum.com/showthread...hreadid=394273
>

[Bob Phillips]

The code is?

Could well be unqualified ranges, such as

Worksheets("Sheet1").Range(Cells(A,1),Cells(2,2))

The Range refers to Sheet1 as it is qualified, but the Cells refer to the
active sheet as they are not.

--
HTH

Bob Phillips

"Andres" <[email protected]> wrote in
message news:[email protected]...
>
> I have a VBA code to calculate a "conditional average" of the days used
> to issued official documents, given a range, and ID of the entity and
> the column I want to calculate.
> When I use the function in the same sheet I have the information to be
> calculated, it works well. However, when using it in a different sheet
> (of the same workbook), an error message is displayed.
> It seems there's a reference problem when working with ranges, but I
> have not found how to solve it.
> Does anybody know what should I change for this function to work
> properly?
> Thank you very much in advance!
>
>
> --
> Andres
> ------------------------------------------------------------------------
> Andres's Profile:
http://www.excelforum.com/member.php...o&userid=26096
> View this thread: http://www.excelforum.com/showthread...hreadid=394273
>