Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic range generator
Hi,
I would like to output a pretty simple equation with a couple of characters in the middle of the answer. So far this wrecks it and i'm guessing the characters are really performing a function (but i want them not to). I'd like to output the following to a cell (RTDMA)*32&&-(RTDMA)*32+31 where RTDMA is a value i enter into a cell elsewhere, which is multiplied by 32 (the product of this is the start of my range) and the same applies to the 2nd RTDMA calc, only it's +31. The ampersands need to denote this is a range. E.G. RTDMA=1 so using the above and calculating manually i'd have 32&&-63 from and RTDMA of 1. Hope you follow me and can help. Rob |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic range generator
=D21*32&"&&-"&D21*32+31
presuming RTDMA is in D21 you might also give D21 a name of "RTDMA" and then use the formula: =RTDMA*32&"&&-"&RTDMA*32+31 HIH |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic range generator
Sub beeb()
Dim s As String, rtdma As Integer rtdma = 1 s = rtdma * 32 & "@@-" & rtdma * 32 + 31 Cells(1, 1).Value = s End Sub -- Gary''s Student - gsnu200797 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dynamic range based on criteria, within a dynamic range, passed to a function | Excel Programming | |||
creating a dynamic range based on criteria, within a dynamic range, and passing it to a function | Excel Programming | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
copying dynamic range based on cell outside of range | Excel Programming | |||
select dynamic range with dynamic start point | Excel Programming |