Hi there,

I'm creating a macro that read database from range [A7] to [A808] so that it
will display the data in a selected column at certain condition. However, it
only can read/execute data until [A607]. can abyone show me how to solve the
problem.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200606/1

Hi Cyzax,

Try posting your code.


---
Regards,
Norman


"cyzax7 via OfficeKB.com" <u22797@uwe wrote in message
news:61cc1bddb4ad6@uwe...
Hi there,

I'm creating a macro that read database from range [A7] to [A808] so that
it
will display the data in a selected column at certain condition. However,
it
only can read/execute data until [A607]. can abyone show me how to solve
the
problem.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200606/1

Hi Cyzax,

It works till [A607] only

In the line::

ElseIf gdblFreq(intEle) = [A457].Value _
And gdblFreq(intEle) <= [A607].Value Then _
'general frequency range for checking

try changing [A607} to [A808}


---
Regards,
Norman

Hi,

First, sorry for the very long code..

I've tried change the value to [A607], but it returns this value (for ex):

TXREJMount Freq
-999 0
-999 0
-999 0
-999 0
-999 0

wherre actually, the freq and the TXREJMount should returned some value
( such as : TXREJMount = -48.0417 and freq = 1928000000 )


Norman Jones wrote:
Hi Cyzax,

It works till [A607] only

In the line::

ElseIf gdblFreq(intEle) = [A457].Value _
And gdblFreq(intEle) <= [A607].Value Then _
'general frequency range for checking

try changing [A607} to [A808}

---
Regards,
Norman

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200606/1

Norman,
You had more patience than I to wade through all that.

NickHK

"Norman Jones" wrote in message
...
Hi Cyzax,

It works till [A607] only

In the line::

ElseIf gdblFreq(intEle) = [A457].Value _
And gdblFreq(intEle) <= [A607].Value Then _
'general frequency range for checking

try changing [A607} to [A808}


---
Regards,
Norman

sorry... for that typing error.

I've change the value to [A808]

cyzax7 wrote:
Hi,

First, sorry for the very long code..

I've tried change the value to [A607], but it returns this value (for ex):

TXREJMount Freq
-999 0
-999 0
-999 0
-999 0
-999 0

wherre actually, the freq and the TXREJMount should returned some value
( such as : TXREJMount = -48.0417 and freq = 1928000000 )

Hi Cyzax,

[quoted text clipped - 11 lines]
Regards,
Norman

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200606/1