Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
This is probably a very stupid question, but how can you change static
references into variables in Visual Basic code? I have this: Sub Test5() ' ' Test5 Macro ' ' Range("A37").Select ActiveCell.FormulaR1C1 = "=5+5" Range("B37").Select ActiveCell.FormulaR1C1 = "=4+4" Range("C37").Select ActiveCell.FormulaR1C1 = "=RC[-2]*RC[-1]" Range("D37").Select With Selection.Interior .Pattern = xlSolid .PatternColorIndex = xlAutomatic .ThemeColor = xlThemeColorAccent6 .TintAndShade = -0.249977111117893 .PatternTintAndShade = 0 End With Range("E37").Select ActiveCell.FormulaR1C1 = "Just testing" Range("A37").Select End Sub I would like the changes to happen on the next row below the active row. How can I do this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Static variables | Excel Programming | |||
Initializing static variables in VBA | Excel Programming | |||
Static Variables | Excel Programming | |||
Static variables | Excel Programming | |||
Static variables | Excel Programming |