| 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 |
| 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 | |||
Threaded Mode
