View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Tomáš Vognar Tomáš Vognar is offline
external usenet poster
 
Posts: 3
Default How to reference an active cell

I've recorded a simple macro for Excel, where I work with a row. But I want
to work with a row the active cell is on, but Macro Recorder has writen me
an absolute referencing. Should anyone help me, how to rewrite the code?

Sub Zašedění_řádku()
Range("A12:W12").Select !!!
With Selection.Interior
.ColorIndex = 15
.Pattern = xlSolid
End With
End Sub

--
Tomas Vognar, beginner, Office XP