Re: Formula in VBA
- From: "Don Guillett" <donaldb@xxxxxxx>
- Date: Sun, 5 Jun 2005 13:03:58 -0500
in the vbe type in match then touch the f1 key
--
Don Guillett
SalesAid Software
donaldb@xxxxxxx
"bharat" <bharat.1q5xpa@> wrote in message
news:2MudnVsNiIEIrT7fRVn_vg@xxxxxxxxxxxxxxx
>
> Hi
> I am a beginner of VBA and this is my first VBA project. I am working
> on this excel matrix (see below a portion of the matrix) and attempt to
> call this matrix in excel *** from VBA.
>
> What I tried to do is select a cell based on the condtion on from and
> to species (JP, SC, RN, RP and WP are speceis code). For example, if
> the condition is RN (from) and JP (to), the VBA function should give
> -0.083 for a variable name A1.
>
> I used a formula (=OFFSET(AB3,MATCH(E5,$AB$4:$AB$71,0),MATCH(C5,$AC
> $3:$CR$3,0))) in Exel ***, it works fine but I tried to use the same
> in VBA in excel, but it does not work. Any help will be highly
> appreciated.
>
> Thanks
> Bharat
>
>
>
>
> From/To JP SC RN RP WP
> JP 0 0 -0.083 -0.083 0
> SC 0 0 -0.083 -0.083 0
> RN 0.081 0.081 0 0 3.926
> RP 0.081 0.081 0 0 3.926
> WP 0 0 -4.094 -4.094 0
>
>
> --
> bharatPosted from http://www.pcreview.co.uk/ newsgroup access
>
.
- References:
- Formula in VBA
- From: bharat
- Formula in VBA
- Prev by Date: Re: Can this be simplified?
- Next by Date: Re: Conditional formatting code wont work
- Previous by thread: Formula in VBA
- Next by thread: Re: Formula in VBA
- Index(es):
