LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
countif with cell ref vs fixed number... griff Excel Discussion (Misc queries) 5 February 18th 08 11:07 AM
Copying fixed cell value from different worksheets to new worksheet [email protected] Excel Discussion (Misc queries) 0 January 29th 07 07:54 PM
Copying the number of a custom formatted number cell fbvideo Excel Discussion (Misc queries) 2 January 25th 07 11:00 PM
How can i specify a cell to have a fixed number of characters john dunford Excel Discussion (Misc queries) 1 January 30th 06 10:08 PM
Can you have fixed cell reference when dragging/copying formulae? ducksfolly Excel Discussion (Misc queries) 4 December 20th 05 11:19 AM


All times are GMT +1. The time now is 01:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"