Re: Custom Fucntion

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Tom Ogilvy (twogilvy_at_msn.com)
Date: 02/10/04

Next message: JimP: "Trying to move a BLOCK of data using 'OFFSET'"
Previous message: Tom Ogilvy: "Re: Yahoo quotes error in Excel"
In reply to: Sa***: "Custom Fucntion"
Next in thread: Sa***: "Re: Custom Fucntion"
Reply: Sa***: "Re: Custom Fucntion"
Messages sorted by: [ date ] [ thread ]

Date: Tue, 10 Feb 2004 10:20:02 -0500

=MyFunc($A$1,B1)

-- 
Regards,
Tom Ogilvy
"Sa***" <anonymous@discussions.microsoft.com> wrote in message
news:d3a401c3efe8$46207810$a101280a@phx.gbl...
> Hi Evereyone,
>
> Say the following custom function:
>
> function MyFunc(A,B)
>
> I want to make A to be absolute reference and B to be
> relative reference. Therefore, when this function is
> copied down a column, A always refers to the same cell. I
> would like to call it and copy down a column using another
> macro and no manual input.
>
> Any help is appreciated.
>

Next message: JimP: "Trying to move a BLOCK of data using 'OFFSET'"
Previous message: Tom Ogilvy: "Re: Yahoo quotes error in Excel"
In reply to: Sa***: "Custom Fucntion"
Next in thread: Sa***: "Re: Custom Fucntion"
Reply: Sa***: "Re: Custom Fucntion"
Messages sorted by: [ date ] [ thread ]