View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] p.numminen@suomi24.fi is offline
external usenet poster
 
Posts: 7
Default Static references into variables

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?