Thread: Offset function
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default Offset function
On Sat, 25 Oct 2008 04:59:21 -0700 (PDT), wrote:

Hi
How can I use Offset function to copy formulae, in one column and 4
rows, or every 4 rowas
Thnaks in Advance
Jam

The OFFSET worksheet function returns a reference to a range. It does not
"copy formulas". This is mentioned in HELP for the OFFSET worksheet function.

If you could be more specific in exactly what you want to do, and present some
concrete examples, we could probably figure something out.
--ron
Reply With QuoteReply With Quote