View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.newusers
JP[_4_] JP[_4_] is offline
external usenet poster
 
Posts: 897
Default How to reference an active cell

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


--JP

On Mar 14, 4:24*am, TomᚠVognar <vognar(zavinac)esys.cz wrote:
The best would be region defined by intersection of the CurrentRegion and
active line. I'm sorry, I'm trying this, but I get errors or wrong results..
I do not quite understand the syntax of the VBA, for the meantime.

T.Vognar