How to reference an active cell

[Tomá¹ Vognar]

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

 

[Bob Phillips]

Sub Za¹edìní_øádku()
With Activecell.Entirerow.Interior
.ColorIndex = 15
.Pattern = xlSolid
End With
End Sub


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Tomá¹ Vognar]

Thank you very much, it works. But is it possible to rewrite it, so that
limited row was marked? (Since Ay to Wy, or using CurrentRegion)

T.Vognar

 

[Bob Phillips]

I am not understanding. Ay to Wy, what is that referring to?

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Tomá¹ Vognar]

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

I am not understanding. Ay to Wy, what is that referring to?

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)

 

[JP]

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


--JP