Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to reference an active cell
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" <vognar(zavinac)esys.cz wrote in message ... 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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to reference an active cell
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" píše v diskusním příspěvku ... 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" <vognar(zavinac)esys.cz wrote in message ... 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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to reference an active cell
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" <vognar(zavinac)esys.cz wrote in message ... 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" píše v diskusním příspěvku ... 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" <vognar(zavinac)esys.cz wrote in message ... 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 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to reference an active cell
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 "Bob Phillips" píše v diskusním příspěvku ... 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" <vognar(zavinac)esys.cz wrote in message ... 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" píše v diskusním příspěvku ... 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" <vognar(zavinac)esys.cz wrote in message ... 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 |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referring to formula in a non active cell from active cell | Excel Discussion (Misc queries) | |||
Active row cell reference | Excel Worksheet Functions | |||
Active cell as a reference to open a worksheet | Excel Worksheet Functions | |||
Active Cell Reference | Excel Worksheet Functions | |||
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions |