"riverman" wrote in message ...
In Excel, how can I make worksheet references relative?

For example, I want to insert the following in row 3, in cells A through
Z:

Sheet2!$B$5 Sheet3!$B$5 Sheet4!$B$5 Sheet5!$B$5 etc.

I know how to make the cell number absolute (with the $-signs), but I
cannot get the 'fill' to change the sheets when I drag the function
command across the different cells in row 3: it keeps the worksheet
reference absolute, referencing Sheet2. How can I make the worksheet
reference relative, so it changes the sheet number for each successive
cell?

--riverman

I subscribe to microsoft.public.excell.worksheetfunctions and it appears to
be a very active NG (53,854 posts).

microsoft.public.excel.newuser had 9746 post

Op