View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
OverlookingSimpleClue OverlookingSimpleClue is offline
external usenet poster
 
Posts: 2
Default copying cell links with fixed number in between

In a column someone wants a reference to another cell. They want this for a
large nr. of cells, with 15 in between

=D15
=D30
=D45
=D60
and so on

I can build a simple VBA module to get this done, but the whole in itself is
variable (for some purposes 15, others 18, in another sheet it'll be a
different column) and the user who needs to do this won't be able to change
anything in the VBA stuff. They will also need this in more worksheets. I've
checked 'paste special' but it doesn't seem to have any functionality for
this.

Any ideas?