select the range with the cell's position is a variable.
Tech-Archive recommends: Fix windows errors by optimizing your registry
can anyone tell me how to select a range which will keep changing? for
eg:
Sub select_range()
Dim abc As Range
Dim a As Integer
Dim b As Integer
a = 2 + 2
b = 2
abc = Range("ab")
abc.Select
End Sub
How to modify the code if i wish to make the a, b as a variable?
.
Relevant Pages
- Project Error
... Private Declare Sub Sleep Lib "Kernel32" ... Dim strDataSrc As String ...
(microsoft.public.vb.bugs) - Re: How Much Longer Can SRians Ignore Their Fundamental Error.
... ecc As Variant ... Dim lightspeed, position, circlerun, Pref, prefmod As Integer, ... Private Sub Combo12_Change ... Erase Vangle ...
(sci.astro) - Re: How Much Longer Can SRians Ignore Their Fundamental Error.
... ecc As Variant ... Dim lightspeed, position, circlerun, Pref, prefmod As Integer, ... Private Sub Combo12_Change ... Erase Vangle ...
(sci.physics.relativity) - Re: Rearrange desktop
... Dim m_htTitlebar ' used in geom calcs ... Const GWL_STYLE = ... Sub RepositionDesktopIcons() ... Public Property Let Mask ...
(microsoft.public.scripting.vbscript) - Re: Is there a way to prevent a RichTextBox from scrolling?
... Private _isRegex As Boolean ... Public Sub New(ByVal thispattern As String, ... Dim entry As tDict ...
(microsoft.public.dotnet.framework.windowsforms.controls) |
|
