Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
countif with cell ref vs fixed number... | Excel Discussion (Misc queries) | |||
Copying fixed cell value from different worksheets to new worksheet | Excel Discussion (Misc queries) | |||
Copying the number of a custom formatted number cell | Excel Discussion (Misc queries) | |||
How can i specify a cell to have a fixed number of characters | Excel Discussion (Misc queries) | |||
Can you have fixed cell reference when dragging/copying formulae? | Excel Discussion (Misc queries) |