P
p.numminen
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?
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?